find if a particular excel file is open b4 doing updates

[Guest]

All,

Before I do the export data from the database to excel, I would like my
application to check if that particular excel file is open. Is it possible?
For example, let's say I want my database to update the file "weekly.xls"
everyweek. Before I do the update, the application should check whether the
"weekly.xls" file is open. The problem with the file being open is I cannot
do the update on that file as the file becomes a read-only when it's open.
Any help would be highly appreciated. Thanks!

 

[Guest]

Just a simple question for you. if you try and update it and it is in use,
does it not generate an error? if so, simply trap the error in your error
handler!

 

[Guest]

Also, you might want to check out

http://support.microsoft.com/kb/138621/en-us

 

[John Nurick]

This is pretty much the standard way of doing it.