PDA

View Full Version : Open Excel Workbook as read Only



ludwigm
07-08-2005, 04:07 AM
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
07-08-2005, 04:24 AM
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
07-08-2005, 08:37 AM
Moved to Excel Help forum. :)