Sleeper: Open Excel Workbook as read Only

I want to open a workbook in order to copy some Info even if the Workbook is allready in use by someone else. This is part of a macro that opens several files to obtain data.

Thanks

Mike

Quote:

---

Originally Posted by ludwigm

I want to open a workbook in order to copy some Info even if the Workbook is allready in use by someone else. This is part of a macro that opens several files to obtain data.

Thanks

Mike

---

Code:

---

'Set Readonly parameters to True
 
Call Workbooks.Open("C:\abc.xls", , True)

---

:hi:

Moved to Excel Help forum. :)