Hi Bob --
Your only options are to rename the file before sending it as an attachment. Now, what you could do is have Excel (through VBA) save the spreadsheet using SaveAs onto a local hard disk to avoid conflicts and then attach the file from the local hard disk.
>We are producing an Excel spreadsheet using SYS(3) for our file naming convention. When I attach this file to an email via VBA is there a way to rename the attachment. For example, I am attaching file 73842324.XLS and want to call it NBLMUsage121598.XLS when it is attached.
>
>Obviously this is a multi-user issue; that's why we are using SYS(3). We cannot risk renaming the file on the hard disk in a multi-user environment.
>
>Thanks, Bob
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05