| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help... File Not Saved | Excel Discussion (Misc queries) | |||
| Problems opening Excel files using DFS links | Excel Discussion (Misc queries) | |||
| Macro - - Automation | Excel Discussion (Misc queries) | |||
| Creating a PDF file programatically from Excel | Excel Discussion (Misc queries) | |||
| This one is tricky....Macro to save file as cell value x in di | Excel Discussion (Misc queries) | |||
Threaded Mode
