GetSaveAsFilename

[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?

 

[Tom Ogilvy]

Set cancel to true in the beforesave event.

 

[Tom Ogilvy]

Please elaborate with sample code and step by step procedures.

--
Regards,
Tom Ogilvy

Another option would be to create a custom event handler that shows the

SaveAs dialog box yourself and you can easily return the value.