VB code to check if a file is open

M

Michael

Hi,

I have this form with Projectdata and whant to export it to excel.

Off course I need to check if the target is open before going any furter.

Could anybody tell me what the syntax is for checking if an excel file is
open?

Txs in advance.

Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Setting a default zoom in Infopath 0
VBA code issue...Would love expert help. 5
Checking filename B4 opened in WORD 0
Open Existing InfoPath File through VBA code 0
using Shell to open an MS Excel file and run a macro 6
Disable printing from standard menu 4
Excel 2007, Unable to save new VB code 1

Top