Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Check for open XLS (Excel XP SP-3)

    I probably should know this one, but...can anyone tell me what is the best way of using VBA to check for an XLS which is already open before I try to open it.

    Thanks for your help

    Nick

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Check for open XLS (Excel XP SP-3)

    If you mean open in the same Excel session, you can loop through the Workbooks collection to see if the workbook name is in there.
    If you mean opened by somebody else (on a network), see here.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Check for open XLS (Excel XP SP-3)

    Hans

    As always, you are spot on.

    Many thanks for that

    Nick

Posting Permissions

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