| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Dialog
Hello.
I'm writing a macro and what i'd like to do is the following: The macro has a source file, that could be on many different locations and with different names. How can i open a dialog box to browse for the source file, and when the user double clicks on the file then the macro continues execution using this file? Thanks Luis |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
File Dialog
Hi
have a look at GetOpenFilename in the VBA help -- Regards Frank Kabel Frankfurt, Germany Luis wrote: Hello. I'm writing a macro and what i'd like to do is the following: The macro has a source file, that could be on many different locations and with different names. How can i open a dialog box to browse for the source file, and when the user double clicks on the file then the macro continues execution using this file? Thanks Luis |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
File Dialog
Perfect!
Thanks a lot! -----Original Message----- Hi have a look at GetOpenFilename in the VBA help -- Regards Frank Kabel Frankfurt, Germany Luis wrote: Hello. I'm writing a macro and what i'd like to do is the following: The macro has a source file, that could be on many different locations and with different names. How can i open a dialog box to browse for the source file, and when the user double clicks on the file then the macro continues execution using this file? Thanks Luis . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File in use Dialog box | Excel Discussion (Misc queries) | |||
| open file dialog-select file-import worksheet | Excel Programming | |||
| Prompt user to select file with default file selected dialog | Excel Programming | |||
| Prompt user to select file with default file selected dialog | Excel Programming | |||
| Prompt user to select file with default file selected dialog | Excel Programming | |||
Linear Mode
