Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Renaming a VBA email attachment
Message
From
17/12/1998 09:25:31
 
 
To
17/12/1998 09:21:48
Robert Byrd
National Association of Homebuilders
Washington, District of Columbia, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00168462
Message ID:
00168465
Views:
24
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
Previous
Reply
Map
View

Click here to load this message in the networking platform