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)


:hi:

[Zack Barresse]

Moved to Excel Help forum. :)