VBA Handle Temporary Files

[wsnyder]

Hi all,

Using Excel 365.

I was running my code and it bombed out on me because one of the Source Files was a temporary file "~$...."
If a temporary file is encountered, how can I convert the temporary file to a normal file so code execution may continue?

Thanks,
-w

 

[GWteB]

You don't want to do that because there's always a reason for a file to be temporary.
In addition, usually you can't do anything with such temporary files, because they are often blocked by the application that created them.

 

[wsnyder]

Thanks,

I opened the offending file in Windows Explorer.
I saved and closed the file.
I re-ran my process and it worked as expected.

The reason it was temporary was because I left it open last night, so when some IT process ran it caused Excel to quit abnormally creating the temp file

I would like to be able to work around this possible future problem so my users do not have the same experience in the future in the likelihood that they leave their files open as well.

Thanks
-w

 

[GWteB]

If you're talking about the temporary and hidden files Excel creates when a workbook is opened - which you didn't tell us - then you can try to delete such a file.
If the corresponding workbook is still open such an attempt will result in an "access denied" and therefore will do no harm.

 

[wsnyder]

Thanks,

I'll try for that approach
The offending workbook is not open.
It is during the opening process that I received the original "~$..."

There are 5 source file that are used in creating a report.
Once the report is created, the source files are closed without saving any changes made during processing since the source file come from IT governed sources/processes and refreshed weekly.

Thanks,
-w

 

[GWteB]

You are welcome and thanks for the feedback