select a file to open when a macro runs

[RobbertH]

Gurus,

I writing some code that performs actions on various files that are saved at different locations. Now i want to give my users the possibility to select the files that should be included in the macro.

So basically, the user will start the macro which performs some actions. At one point the macro asks to open a file and when the file is opened the macro continues running.

Hope you have an idea. Thanks

Robbert

 

[jim may]

see GetOpenFilename in Help

 

[RobbertH]

Thanks Jim,

I got it to work.
Other question.
When the file is opened it might require some changes. (The macro can check whether these changes are required). How do i allow the user to make the changes before continuing the macro?

Cheers! Robbert

 

[jim may]

Please Post your code