View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] dswiders@gmail.com is offline
external usenet poster
 
Posts: 19
Default Opening a file with User Input

I am saving files based on a number and in the macro I need the user
to input the number for the file they wish to open and have the rest
of the macro continue. Right now I am using an InputBox to have the
user input the information but I dont know how to use the variable
that saves the users information and have it apart of the Open
Filename command. This does not work because that command needs to
have text and it wont let me put a variable in there. Any suggestions?