Re: Call the Save As dialog

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

ans = Application.GetSaveAsFilename(filefilter:="*.xls, *.xls")
This won't save the file, but will place the file name & path in the
variable Ans. Then you can save it via
Activeworkbook.SaveAs ans

"cdb" <cdb@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:449DDD80-42AC-4A05-BC7F-E62873D90835@xxxxxxxxxxxxxxxx
I have a macro that copies data from one spread*** into a new workbook.
At
the end I want to call the Save As dialog for the user to enter a file
name
and save straight away.

I know this is probably dead easy, but I just can't get it working.

cdb


.

Quantcast