ChuckDrago
Active Member
- Joined
- Sep 7, 2007
- Messages
- 470
- Office Version
- 2010
- Platform
- Windows
Hi everyone!
I have a macro that opens up a template (e.g. MyTemp.xlt), the user fills in data and then clicks a Send button, which shoots an e-mail with the file attached. Now, the filename is not MyTemp.xlt anymore... now it is MyTemp1.xls (which I interpret as a means to retain the template blank, as intended).
I have been testing this macro for enhancements and optimization, when I noticed that the name of the last attachment was MyTemp1(23)(2).xls. Woooaa!...
What does that mean? Are there 23 + 2 copies somewhere in my computer??? Or in the Outlook server??? Should I use a Kill statement, after the e-mailing?
Not pressing, but interesting...
Chuck
I have a macro that opens up a template (e.g. MyTemp.xlt), the user fills in data and then clicks a Send button, which shoots an e-mail with the file attached. Now, the filename is not MyTemp.xlt anymore... now it is MyTemp1.xls (which I interpret as a means to retain the template blank, as intended).
I have been testing this macro for enhancements and optimization, when I noticed that the name of the last attachment was MyTemp1(23)(2).xls. Woooaa!...
What does that mean? Are there 23 + 2 copies somewhere in my computer??? Or in the Outlook server??? Should I use a Kill statement, after the e-mailing?
Not pressing, but interesting...
Chuck
