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.