Save As sub not saving

[imatomic]

The dialog box comes up with file name formatted correctly and shows .xls as file type but when you choose save the dialog box disappears as if the file was saved but the file never gets saved. What am I doing wrong?

Please Login or Register  to view this content.

Thanks much for any help.
Barry

[mikerickson]

I would avoid naming a sub SaveAs, since there is a method by that name.

GetSaveAsFileName returns a path (a string), but doesn't actualy save the file.
You could either:
Add a bit that saves the workbook

Please Login or Register  to view this content.

or you could use the built in dialog

Please Login or Register  to view this content.

[Leith Ross]

Hello Barry,

The GetSaveAsFilename only returns the file name along with its directory path. It doesn't actually do the saving. You have to do that.

[imatomic]

Thanks Mike

I went with the first option and learned something along the way. Thank you very much for the help!

Barry