SaveAs via VBA code

[ainnocent1983]

I'm sure this is a very simple one for most people! I'm trying to run a save as from code, but has a variable filename and to a variable directory so needs user input.

I have set the ChDir to the root directory and used the GetSaveAsFilename application to open the save as dialogue box. This opens up the Save As box, to the correct directory, with the filename in the correct box. However, when I hit save, the box closes, sub ends as planned but the file has not been saved.

Any ideas?
Cheers
A

Please Login or Register  to view this content.

[nchavan]

Hi,

Please try below code:

Please Login or Register  to view this content.

[JeanRage]

Hi,

You right with the variables ...
With your full path (i.e. including the drive letter) stored in the variable strwkbPath, and
your file name stored in the variable strwkbName, you could use
following intruction :

Please Login or Register  to view this content.

HTH

[buran]

Hi,
GetSaveAsFileName display the standard dialog and get user input, but doesnot save anything. Use something like this:

Please Login or Register  to view this content.

Eventually, instead of

Please Login or Register  to view this content.

you may use

Please Login or Register  to view this content.

to save only one sheet as different workbook


@nchavan: In your code, if user select to Cancel it will save the file with name False.xls
Also, if you use ThisWorkbook and the routine is in Add-in, it will save the add-in.