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
|