What i require is quite simple.

I have created a macro which extracts data from specfic spreadsheets
The spreadsheets are in constant use and i there need to know th
following:

If the macro automatcly opens the spreadsheet and no one else is usin
it it will open normally, but if the macro opens the file and it is i
the read only box appears will the macro just go in as read only o
will i have to place code to tell the macro to go in as readonly?

If i require code can you please give an exampl

--
Message posted from http://www.ExcelForum.com