Search results for query: *

Thanks everyone - I missed that as well!!

...= False Application.DisplayAlerts = False MyInitialPathAndFilename = "C:\test\testfile2.xls" fileSaveName = Application.GetSaveAsFilename(MyInitialPathAndFilename, "Excel (*.xls), *.xls") If fileSaveName <> False Then SaveAs fileSaveName End If Application.EnableEvents = True

...= False MyInitialPathAndFilename = "C:\test\testfile2.xls" Application.EnableEvents = False fileSaveName = Application.GetSaveAsFilename(MyInitialPathAndFilename, "Excel (*.xls), *.xls") If fileSaveName <> False Then SaveAs fileSaveName End If Application.EnableEvents = True

...in the same bit of code being re-run at the saveas line so you are prompted twice to save! MyInitialPathAndFilename = "C:\test\testfile.xls" fileSaveName = Application.GetSaveAsFilename(MyInitialPathAndFilename,"Excel (*.xls), *.xls") If fileSaveName <> False Then SaveAs fileSaveName...

Skip, I have read it but it dosn't seem to work as expected. The example allows you to get a savename/location and going on, I would expect to use the "saveas" command to save the file with a "cancel = true" at the end of the routine to stop the default save routine from running. However as it...

...As Boolean, cancel As Boolean) Dim fileSaveName As String fileSaveName = Application.GetSaveAsFilename("my documents\Timesheet""Excel Files (*.xls), *.xls") Application.ActiveWorkbook.SaveAs fileSaveName What keeps happening is that when the user presses Cancel on the save as dialog, the...

Thanks Tony the Cancel = True does the trick Georg

Hi, I need to trap the save or SaveAs controls on the menubar, so I can control where and when the user saves a document. It's easy enough to see how the BeforeSave sub works, putting my own save commands in, but the problem is that when the code finishes, it still opens the standard save...

OK got it... Workbooks(1).Worksheets(1).Range("a1") = "hahaha" This stuff will be the death of me one day Thanks for the help Georg

as in worksheets(1).Range("a1").Value = "hahahaha" ?? Tried it already...that throws up "Application-defined or object-defined error" Georg

Hi all. Can anyong shed light on this problem. I have an XL sheet with the following code on a command button in the sheet: Range("a1").Value = "hahahaha" The same code is placed in a command buttton, but on a userform. Both work as expected. However, I now hyperlink to the sheet from a web...

Ok it was close.. After I changed it to this it worked... Activesheets.OLEObjects("ComboBox" & var).Object.Value Many thanks Georg

Mike Not quite - came up with 'Subscript out of range' After I changed it to this it worked... Activesheets.OLEObjects("ComboBox" & var).Object.Value Many thanks Georg

Skip, Thanks, but looks like shapes properties don't include .value, only format properties I tried messing with Worksheets("SheetName").OLEObjects("ComboBox" & var).Object.Value on advice from another guy but comes up with 2Suvscript out of range'... Georg

Hi Skip, it's excel. The boxes are on the sheet - 3 per row, 31 rows - 93 combl boxes labeled combobox1-90 Thanks Georg

No, it's on the sheet it'self. There are 90 combos in total (3 per row, one row per month) combobox1-90 Thanks Georg

Hi, I am trying to reference a particular combobox in excel. I know you can use a variable to reference cells etc such as: For var = 1 to 10 range("A" & var).select .... next but what about a combobox. I need to be able to change the value in a particular combobox out of a range of boxes...

Hi, I know you can use a variable to reference cells etc such as: For var = 1 to 10 range("A" & var) - dosomethin next but what about a combobox. I need to be able to change the value in a particular combobox out of a range of boxes, but this won't work (ie need to get to combobox5): var = 5...

Well the users can't see them but they are a pain when I am working in tables. You are right is as much as they are a hangover from whem I had the tables replicated but they aren't any more. Don't know why the fields are visible tho? I have found a fix by running a create-table query for each...

I have converted a DB from access97 to 2000. Now I have 3 extra field in each table S_Guid, S_Generation and S_Lineage. I can hide them but they keep coming back? Can anyone please tell me how to get rid of them. Can I just delete them? Thanks