Check if excel workbook is open

2 posts / 0 new
Last post
pcallan0
Offline
Joined: 02/21/2017 - 07:17
Check if excel workbook is open

Hi Brian,
 
I hope you are well.
 
I'm running a macro that creates an excel output file.
 
If the macro has been run previously, and the user has that excel output file open, the macro will crash when it tries to export.
 
To avoid this, I would like to use my script to check if any previously exported excel file is open.
 
The macro can then pause, prompt the user to close the file, and then will overwrite it.
 
 
I have searched the forum and see a similar question was asked some years ago.
 
However, you noted at the time that the code was quite complex.
 
I'm hoping that you might have come across this situation since then and maybe have a workable solution?
 
As always,
 
thanks in advance,
 
Phil
 

pcallan0
Offline
Joined: 02/21/2017 - 07:17

Wondering if anyone can help on this please?
Basically need the script to check if a specific excel file is open .
Thanks,
Phil