GetSaveAsFilename

  • Thread starter Thread starter libby
  • Start date Start date
L

libby

Hi

I want to use GetSaveAsFilename to get the SaveAs dialogue
box with the contents of a cell in the Name field.

I've managed to do this by putting the code in the
BeforeSave event.
However, the workbook is a .xlt template and after the
SaveAs dialogue box that I've generated has been closed,
another one appears.

Any ideas how I can stop this happening?
 
Please elaborate with sample code and step by step procedures.

--
Regards,
Tom Ogilvy

MikeRulzTheWorld said:
Another option would be to create a custom event handler that shows the
Click to expand...
SaveAs dialog box yourself and you can easily return the value.
 
Back
Top