Checking if an excel file is open in vba.

[ammiller]

OK,

I have a macro that opens up a spreadsheet and copies data into a new spreadsheet.
A problem I have encountered is when users run the macro but the data source spreadsheet is still open. The macro will only read what was on the last saved version of that spreadsheet.

How do I check if the file is already open? If it is I will put in an error message and close the macro.

I have tried to see what happens when I open a spreadsheet which is already open where I specify readonly = false. I would expect an error message, but instead the macro opens up a copy of the file as read-only.

Anyone any ideas?

Thanks

Aidan

 

[Stretchwickster]

I posted this question in mid-June so here's the link: thread707-580802

Clive

http://www.kucu.co.uk

Ex nihilo, nihil fit (Out of nothing, nothing comes)