Recent content by cg084

Hello, I have been tasked with reviewing a whole host of databases. There are about 70 databases which i need to review. I need to analyise all aspects of these databases. This includes all the field names in each table as well as the field names a description of the format and attributes of...

Hi All, I have managed to figure it out. This wont work cause it wants to put the code in a module. So replace Sheets(1).Name with "Module1" it will need to exist before hand though. ActiveWorkbook.VBProject.VBComponents(Sheets(1).Name).CodeModule.addfromstring _ "Private Sub...

Hi All, I am using a similar method. ActiveWorkbook.VBProject.VBComponents(Sheets(1).Name).CodeModule.addfromstring _ "Private Sub Worksheet_Change(ByVal Target As Range)" & vbCrLf & vbTab & _ "MyRow = Target.Row" & vbCrLf & _ "Cells(MyRow, 22).Value = Date" & vbCrLf & _ "End...

Hi, I just wanted to see if anyone had any thoughts with why a normal filepath works ok with the above but when i change to use a path to a webfile it does not. Thank you. CG084

Ken, Many thanks for that. It was indeed opening in modal mode. I never came across that behaviour before. But then i was using Access 2k before. Many thanks Craig.

Hello, This has got me stumped. I have been asked to amend a database very simple chance i just have to add a single field to a couple of tables and forms. But i have noticed that i am unable to use the database window while i have a form open. I am finding this rather strange. It is something...

Sam, Greatly appreciate the help. It now works with a local or a named drive. Your help is greatly appreciated. There is still a problem in accessing the file on an internet server. My open file macro works with the same string but does not work in this method. Due to the nature of the file...

Sam, Cheers for the help. I am still a little stuck though. The function seems to do not a lot. I have entered the funtion in to my personal.xls spreadsheet that loads by default when excel opens. From this file i have a macro that will open the file i need from a web server...

Hello, I am trying to write a macro that will check to see if a text file is less than 7 days old. If it is to open the file. The name of the file is fixed and is created though an automated query on a database. The file output is a pipe (|) delimited text file. The file is called. Cluster.txt...

Hello, I am trying to create a macro that will copy a different macro in workbook1 to a named sheet in another workbook. e.g Workbook 1 Contains Sheet1 Contains MacroA Workbook2 Contains Sheet1 I need to write a macro that will copy Workbook 1 Sheet1 MacroA and place it in...

macropod, You spotted that. I forgot to mention that this toolbar allready has 2 buttons on it. So when the above subs run it should add it after them. Cheers CG084

Hello, I have added a button on to a toolbar in excel through the use of a macro. I would like to remove just this one button from the curtom toolbar. I have used the following code to create the button on the toolbar and the second sub is to remove the button when clicked. Sub...

Hello, I have added a button on to a toolbar in excel through the use of a macro. I would like to remove just this one button from the curtom toolbar. I have used the following code to create the button on the toolbar and the second sub is to remove the button when clicked. Sub...

Hi all, I have code that will run through all the open spreadsheets and make a check on them. When a sheet Fails i want the code to pause while the operator has change to close, save & close the spreadsheet or to make amendments. I would like to resume the code from where it paused through the...

Thank you for your help. CG084