Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need simple prompt to save at end of macro
I just want to bring up the "save as" prompt at the end of my macro so that
the user knows when the function is complete and ready to save. I don't want to assign a path or filename, they will do that manually. tia, Kelli |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need simple prompt to save at end of macro
Put the following line of code at the end of your macro:
Application.Dialogs(xlDialogSaveAs).Show -- Kevin Backmann "KelliInCali" wrote: I just want to bring up the "save as" prompt at the end of my macro so that the user knows when the function is complete and ready to save. I don't want to assign a path or filename, they will do that manually. tia, Kelli |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need simple prompt to save at end of macro
Perfect... thanks Kevin! Is it possible to assign the "save to" folder as a
shared network folder? \\Bkstrfile\buyer inv kelli "Kevin B" wrote: Put the following line of code at the end of your macro: Application.Dialogs(xlDialogSaveAs).Show -- Kevin Backmann "KelliInCali" wrote: I just want to bring up the "save as" prompt at the end of my macro so that the user knows when the function is complete and ready to save. I don't want to assign a path or filename, they will do that manually. tia, Kelli |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need simple prompt to save at end of macro
This line of code, placed somewhere before your "SaveAs" line should do it: Application.DefaultFilePath = "\\Bkstrfile\buyer inv" -- Kevin Backmann "KelliInCali" wrote: Perfect... thanks Kevin! Is it possible to assign the "save to" folder as a shared network folder? \\Bkstrfile\buyer inv kelli "Kevin B" wrote: Put the following line of code at the end of your macro: Application.Dialogs(xlDialogSaveAs).Show -- Kevin Backmann "KelliInCali" wrote: I just want to bring up the "save as" prompt at the end of my macro so that the user knows when the function is complete and ready to save. I don't want to assign a path or filename, they will do that manually. tia, Kelli |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need simple prompt to save at end of macro
It still defaulted to Documents folder. I tried just changing the directory
though ChDir "\\Bkstrfile\buyer inv" and that seems to work. Thanks for your help Kevin!!! "Kevin B" wrote: This line of code, placed somewhere before your "SaveAs" line should do it: Application.DefaultFilePath = "\\Bkstrfile\buyer inv" -- Kevin Backmann "KelliInCali" wrote: Perfect... thanks Kevin! Is it possible to assign the "save to" folder as a shared network folder? \\Bkstrfile\buyer inv kelli "Kevin B" wrote: Put the following line of code at the end of your macro: Application.Dialogs(xlDialogSaveAs).Show -- Kevin Backmann "KelliInCali" wrote: I just want to bring up the "save as" prompt at the end of my macro so that the user knows when the function is complete and ready to save. I don't want to assign a path or filename, they will do that manually. tia, Kelli |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do you wish to save prompt | Excel Discussion (Misc queries) | |||
save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
How to CANCEL file SAVE PROMPT when MACRO is running? | Excel Discussion (Misc queries) | |||
CLOSE ALL macro for XL2K (but with prompt to save for each file)? | Excel Programming | |||
Can a MACRO prompt for the filename to open and/or save? | Excel Programming |