Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Renaming a VBA email attachment
Message
De
17/12/1998 09:25:31
 
 
À
17/12/1998 09:21:48
Robert Byrd
National Association of Homebuilders
Washington, District de Colombia, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00168462
Message ID:
00168465
Vues:
19
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform