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
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
Originally Posted by ludwigm
'Set Readonly parameters to True Call Workbooks.Open("C:\abc.xls", , True)
Moved to Excel Help forum.
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables