Hi,
Excel when saving a file creates an 8 character random filename which it saves the file into, then after it is complete it renames the temp file name to the actual file name
e.g. myfile.xls --> save file --> temp file called 63ECD800 --> save completes --> myfile.xls deleted --> 63ECD800 renamed to myfile.xls --> save complete.
http://support.microsoft.com/kb/814068 ...explains this
Question - can this TEMP FILE NAME be forced to be something else?
e.g. 63ECD800.tmp or ~myexcelsheet.tmp
Reason - windows desktop search tries to access the temp file while excel is still using it. This causes excel to leave the filename at the temp name.
If I can add a .tmp to the file name I can tell windows desktop search to ignore it.
(this problem seems to be fairly widespread; but most users can't diagnose the fault. I only noticed it one day when the search kept the file locked..)
Unfortunately trying to get the message to the W.D.S. developers is impossible!!
I googled this and did not really turn up anything.
Thanks
Craig.
Excel when saving a file creates an 8 character random filename which it saves the file into, then after it is complete it renames the temp file name to the actual file name
e.g. myfile.xls --> save file --> temp file called 63ECD800 --> save completes --> myfile.xls deleted --> 63ECD800 renamed to myfile.xls --> save complete.
http://support.microsoft.com/kb/814068 ...explains this
Question - can this TEMP FILE NAME be forced to be something else?
e.g. 63ECD800.tmp or ~myexcelsheet.tmp
Reason - windows desktop search tries to access the temp file while excel is still using it. This causes excel to leave the filename at the temp name.
If I can add a .tmp to the file name I can tell windows desktop search to ignore it.
(this problem seems to be fairly widespread; but most users can't diagnose the fault. I only noticed it one day when the search kept the file locked..)
Unfortunately trying to get the message to the W.D.S. developers is impossible!!
I googled this and did not really turn up anything.
Thanks
Craig.