LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
darrenrwood
 
Posts: n/a
Default File name changes on opening - adds a number to end

I am receiving e mails each week which include a excel 97 spreadsheet. I then
open the spreadsheet and use it within excel.

However on occassions the file name changes from say "fredbloggs" to
"Fredbloggs1" and this seems to be because there is already a file ( albeit
not open ) named "frebloggs" in the temp folder from the last time i used it.

Is there a way to stop this number being added to the name or a way of
deleting the .xls files in the temp folder automatically when windows starts
?

Whatever the solution I need to keep it simple as others will be carrying
out this task who have very little pc knowledge. Its working on Windows NT.

And just in case it matters the reason i dont want the file name to change
is that there is a macro which chooses the spreadsheet by name and this fails
if the name is changed.

I hope this makes sense, any help would be very much appreciated

Darren
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening an Excel File jedi249 Excel Discussion (Misc queries) 5 April 16th 05 11:44 PM
Opening a file with code without a set file name jenkinspat Excel Discussion (Misc queries) 1 March 4th 05 10:50 AM
Opening a file with a Macro Adam1 Chicago Excel Discussion (Misc queries) 2 February 28th 05 10:13 PM
Problem Opening An Excel file. - by yk ilikecy Excel Discussion (Misc queries) 0 February 4th 05 08:19 AM
restrict opening Excel file residing on a shared drive to one user k-ham Excel Discussion (Misc queries) 1 January 7th 05 01:57 AM


All times are GMT +1. The time now is 05:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"