On opening excel file attachment in outlook it opens with a suffix 001, 002

Hi experts,

On opening an excel file attachment in MS outlook it opens with a suffix 001, 002 to the current workbook name at times.

i have a vba macro which reads the current name as CurrentName = ActiveWorkbook.Name and i do not want this suffix .

If i restart my system and then open the excel attachment this suffix never comes.

Is there anyway i can prevent this suffix from coming while opening the excel attachment without restarting the system.

Thanks,
Aaron.

If you want to perform actions in a file with macros, NEVER open the file directly from Outlook. First, save the file to a location convenient to you and open it from that location.
When a file is opened directly from Outlook, a copy of the file is first saved in that program's temporary directory (can't remember the location on the disk), and only then is the file opened from that location. Subfolders are created in the temporary directory. Unfortunately, I don't understand the idea of creating them. When you open an Outlook file twice, a copy is saved in one of those subfolders. If a file with the same name exists in the subfolder, the new file has an incremented suffix in its name.

Artik

yes you are right, i wish to know the location where the temporary file is stored and if i can use a batch file command to delete it..instead of restarting my system.

Anyone know the location where the temporary file is stored and if i can use a batch file command to delete it..instead of restarting my system.

I don't know anything about Outlook. I see a problem with finding an event that will trigger when opening an attachment (or more precisely - BEFORE opening an attachment). If you can find such an event, then the rest of the code should not be much of a problem anymore.

But maybe you need to do it differently. Why do you make the further operation of the code dependent on this line

Please Login or Register  to view this content.

Perhaps it can be solved differently. But then we need to know the code that uses CurrentName.

Artik