Check if file is open before sending the data

[sabavno]

Hi

I export some data into the excel spreadsheet...so what I want to do is to check it the file is open before I do my transfer

Please suggest.

Thanks

 

[KathyD]

Hi there.

I recently had this problem myself. I found this to work:

Workbooks.Open Filename:= abc.xls
If ActiveWorkbook.ReadOnly = True

Hope this helps.

Cheers

KathyD