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

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

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
.