Sleeper: Open Excel Workbook as read Only

[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

[chandansify]

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

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

[Zack Barresse]

Moved to Excel Help forum.