Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
have excel prompt for a file name and save location
I have a macro that parses a table, filters it according to some criteria,
and then copies the filtered records to a new file. What code can I use to prompt the user to 1) Enter a file name 2) Browse to a specific network location to save the file (which can vary each time the macro is run) I'm assuming these two questions would make use of the MsgBox command but I'm not sure exactly how it would look. Thanks for any hints. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prompt for file location and copy data | Excel Discussion (Misc queries) | |||
Prompt to save file | Setting up and Configuration of Excel | |||
save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
Prompt for Save when closing a file | Excel Discussion (Misc queries) | |||
how to disable save prompt on closing excel file in automated mode | Excel Discussion (Misc queries) |