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