Importing from Excel using VB

[Slarti]

Is there away to identify whether a User has an Excel file opened before attempting to import into VB allowing me to inform the user of the VB App to try at a later time?Effectively has the Workbook object got an InUse property?

thanks,

Slarti.

 

[tb]

Do you want to know if the user has a spesific excel file open ... or just running excel (any file) ?

I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!

 

[Slarti]

I want to know if a specifc file on a shared drive is open by anyone. (I don't need to know who necessarily).

 

[tb]

I don't know if that is possible as they can open it from a shared folder, but the actual processing is on their local pc ....


I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!