number "1" added to filename
 

When i open a spreadsheet that has been sent to me in an e mail instead
of it opening in excel with the same filename as it was recorded in the
e mail it adds a "1" to the end.

So file "expenses" becomes "expenses1"

Anyone know if you can stop this happening ?

Thanks

Darren


--
DarrenWood
------------------------------------------------------------------------
DarrenWood's Profile: http://www.excelforum.com/member.php...o&userid=16460
View this thread: http://www.excelforum.com/showthread...hreadid=383664

My guess is that your email program is altering the file name, not
Excel. Try saving the file from the email and open it from the saved
location.

Does that solve the problem?

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=383664

Yes Bruce you are right, that does get around the problem, it is just a
pain in the rear !!

There must be a way around it to stop this happening, any ideas anyone?


--
DarrenWood
------------------------------------------------------------------------
DarrenWood's Profile: http://www.excelforum.com/member.php...o&userid=16460
View this thread: http://www.excelforum.com/showthread...hreadid=383664

The E-mail file may be a template


"DarrenWood" wrote:


When i open a spreadsheet that has been sent to me in an e mail instead
of it opening in excel with the same filename as it was recorded in the
e mail it adds a "1" to the end.

So file "expenses" becomes "expenses1"

Anyone know if you can stop this happening ?

Thanks

Darren


--
DarrenWood
------------------------------------------------------------------------
DarrenWood's Profile: http://www.excelforum.com/member.php...o&userid=16460
View this thread: http://www.excelforum.com/showthread...hreadid=383664

Ok, it might be a template but can you expand on that,

how do i know if it is ? and if it is how do i stop it renaming itself
?

Thanks


--
DarrenWood
------------------------------------------------------------------------
DarrenWood's Profile: http://www.excelforum.com/member.php...o&userid=16460
View this thread: http://www.excelforum.com/showthread...hreadid=383664

Find out where that email program stores its attachments.

=cell("filename",a1)

should show you.

Then clean that up every so often.

(I'm guessing that the number gets added when the email program finds an
existing file of the same name.)

DarrenWood wrote:

Yes Bruce you are right, that does get around the problem, it is just a
pain in the rear !!

There must be a way around it to stop this happening, any ideas anyone?

--
DarrenWood
------------------------------------------------------------------------
DarrenWood's Profile: http://www.excelforum.com/member.php...o&userid=16460
View this thread: http://www.excelforum.com/showthread...hreadid=383664

--

Dave Peterson

Hi Dave

Your spot on. If I open the e mail that has the file in and then open
the file this opens up ok in excel with the correct file name.

However if after this i then close the e mail which contains the saved
file whilst the file is still open in excel you get the normal reminder
"A program still has the file attachemnt " ".xls opem. changes to
this doc................."

If you then close the excel spreadsheet and then reopen outlook and
try to reopen the file this is when it gets renamed, and as you say if
you search on the file name it is in the C drive temp folder.

I assume this temp folder is cleared each time the pc is shut down,
however any thoughts on how i could stop the file being stored in the
temp folder after i shut down the e mail containing the file ?


--
DarrenWood
------------------------------------------------------------------------
DarrenWood's Profile: http://www.excelforum.com/member.php...o&userid=16460
View this thread: http://www.excelforum.com/showthread...hreadid=383664

The files in the temp folder are deleted by the program that created them -- if
that program can and if that program is nice.

But not all files can be deleted (like when you close the email program before
closing the workbook in excel) and not all programs are nice.

I have a VBS script in a folder and a shortcut to it on my desktop.

Since there are lots of programs that fail to clean up after themselves, I like
to run it on demand--either right when I turn on the pc or right before I shut
it off.

It was written by Michael Harris:
http://groups.google.com/groups?thre...%40tkmsftngp02





DarrenWood wrote:

Hi Dave

Your spot on. If I open the e mail that has the file in and then open
the file this opens up ok in excel with the correct file name.

However if after this i then close the e mail which contains the saved
file whilst the file is still open in excel you get the normal reminder
"A program still has the file attachemnt " ".xls opem. changes to
this doc................."

If you then close the excel spreadsheet and then reopen outlook and
try to reopen the file this is when it gets renamed, and as you say if
you search on the file name it is in the C drive temp folder.

I assume this temp folder is cleared each time the pc is shut down,
however any thoughts on how i could stop the file being stored in the
temp folder after i shut down the e mail containing the file ?

--
DarrenWood
------------------------------------------------------------------------
DarrenWood's Profile: http://www.excelforum.com/member.php...o&userid=16460
View this thread: http://www.excelforum.com/showthread...hreadid=383664

--

Dave Peterson

Does the attachment have a .xls extension or a .xlt extension.

If it has a .xlt extension, then it's probably a template. Excel will use that
for the basis of a new workbook.



DarrenWood wrote:

Ok, it might be a template but can you expand on that,

how do i know if it is ? and if it is how do i stop it renaming itself
?

Thanks

--
DarrenWood
------------------------------------------------------------------------
DarrenWood's Profile: http://www.excelforum.com/member.php...o&userid=16460
View this thread: http://www.excelforum.com/showthread...hreadid=383664

--

Dave Peterson

Mike

I tried using the code in the link you provided to clear out the temp
file.

Each time in run the code it stops at

redim preserve arfiles(count)

and gives the error message 'Compile error variable not defined'

any ideas?

Thanks

Darren


--
DarrenWood
------------------------------------------------------------------------
DarrenWood's Profile: http://www.excelforum.com/member.php...o&userid=16460
View this thread: http://www.excelforum.com/showthread...hreadid=383664

Mike?

That link to the .vbs code is not used in excel's VBA.

Open NotePad
copy Michael Harris's code there.
Save it as
deletetempfiles.vbs
(in a nice safe subfolder)

create a shortcut on your desktop to that .vbs file and double click on the
shortcut.

DarrenWood wrote:

Mike

I tried using the code in the link you provided to clear out the temp
file.

Each time in run the code it stops at

redim preserve arfiles(count)

and gives the error message 'Compile error variable not defined'

any ideas?

Thanks

Darren

--
DarrenWood
------------------------------------------------------------------------
DarrenWood's Profile: http://www.excelforum.com/member.php...o&userid=16460
View this thread: http://www.excelforum.com/showthread...hreadid=383664

--

Dave Peterson