Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You could also try the following technique to get the filename (I prefer
this method, as it eliminates having to check the validity of the filename): Dim strFileName As String strFileName = Application.GetOpenFilename(FileFilter:="Excel Files (*.xls),*.xls", _ Title:="Select Document Version Control Log") This only gets the file name without actually opening the file. Just remember that the value of strFileName will be "False" if the user cancels out of the dialog box. -- Regards, Bill Renaud |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking data that won't change when original formula changes | Excel Discussion (Misc queries) | |||
Formula for change background according to data | Excel Discussion (Misc queries) | |||
Need a formula to change data result weekly. | Excel Worksheet Functions | |||
How does Data Validation change with a formula change? | Excel Worksheet Functions | |||
How do change formula to permanent data? | Excel Discussion (Misc queries) |