Selecting filename in Visual Basic

  • Thread starter Thread starter Bruce Htown
  • Start date Start date
B

Bruce Htown

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?
 
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.
 
Back
Top