I am trying to write a macro using VBA that prompts the user to make a
filename selection in order to make the necessary changes to each workbook.
The same macro will be run on each workbook.

Your post is a little thin on details. Are the files already open? Are they
XL files? Did you just need to get a list of file names or do you need to
open the files?

--
HTH...

Jim Thomlinson


"Bruce Htown" wrote:

I am trying to write a macro using VBA that prompts the user to make a
filename selection in order to make the necessary changes to each workbook.
The same macro will be run on each workbook.

Here is the longer version. I have created a Macro in order to make
corrections to an Excell spreadsheet from a Master template. The macro is
setup to make the changes to the selected spreadsheet, but I need to have the
ability to have the user select the file since we have about 700 to 800 files
that need to be corrected. The problem that I have is creating the script to
prompt the user to select the file. I have tried the "FileName" select
script but I get an error message and the macro stops running.

"Jim Thomlinson" wrote:

Your post is a little thin on details. Are the files already open? Are they
XL files? Did you just need to get a list of file names or do you need to
open the files?

--
HTH...

Jim Thomlinson


"Bruce Htown" wrote:

I am trying to write a macro using VBA that prompts the user to make a
filename selection in order to make the necessary changes to each workbook.
The same macro will be run on each workbook.

Application.GetOpenFilename opens the native Excel "Open" dialog and
returns a user-selected filename as a string variable:

See
http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx


HTH,
JP

On Mar 18, 5:55*pm, Bruce Htown
wrote:
Here is the longer version. *I have created a Macro in order to make
corrections to an Excell spreadsheet from a Master template. *The macro is
setup to make the changes to the selected spreadsheet, but I need to have the
ability to have the user select the file since we have about 700 to 800 files
that need to be corrected. *The problem that I have is creating the script to
prompt the user to select the file. *I have tried the "FileName" select
script but I get an error message and the macro stops running.