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

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

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

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

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