Paul,
Basically you can't. You either set the filename to use and call .SaveAs
yourself, or you let Excel handle it and see what it is after.
What do you have against GetSaveAsFilename ?

NickHK

"Paul S" ...
I was wondering if it is possible for a macro to get information from the
drop down menus; specifically the File-Save and SaveAs menus. I would
like
to get the name of the file the spreadsheet is being saved as, without
using
Workbook.FullName or GetSaveAsFilename. I have searched in Excel VBA
help,
books and online, but haven't seen anything listed.
--
Thanks,
Paul S