Consulting

Results 1 to 3 of 3

Thread: Open Excel Workbook as read Only

  1. #1
    VBAX Newbie
    Joined
    Jul 2005
    Posts
    1
    Location

    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

  2. #2

    Smile

    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

    'Set Readonly parameters to True

    Call Workbooks.Open("C:\abc.xls", , True)



  3. #3
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,897
    Location
    Moved to Excel Help forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •