I assume you're using GetSaveAsFileName. The variable that
receives the result of GetSaveAsFilename should be declare as
Variant not String.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ljsmith"
wrote in message
...

For the type of work I do, I must lock down Excel spreadsheets
for legal
and risk reasons. We try to automate the spreadsheets as much
as
possible, and the main focus on current work is save and send
functionality.

I have that working perfectly - including the generation of
filename/subjectline through either specified information in a
setInfo
procedure or derived from information input by users.

However, when the user launches a save and send routine, if
they cancel
the save procedure (which is required for the send routine) it
produces
the FALSE.xls file.

Has anyone figured out how to prevent this?


--
ljsmith
------------------------------------------------------------------------
ljsmith's Profile:
http://www.excelforum.com/member.php...o&userid=30531
View this thread:
http://www.excelforum.com/showthread...hreadid=501828