View Single Post
  #1   Report Post  
Ramius
 
Posts: n/a
Default How do I force an Excel macro to ask me which file and directory?

I recorded an Import External Data macro that I wish to use on other files.
It works beautifully, but only on that one specfic file in that one
directory. I can get the Visual Basic code for that macro to where I can
edit it, but don't know what to substitute for the directory/file so that the
macro is forced to ask.