Results 1 to 2 of 2

Thread: Check if a file is already open

  1. #1

    Thread Starter
    Fanatic Member coox's Avatar
    Join Date
    Oct 1999
    Posts
    550
    Hi, must be easy this, just want to check if any instance of Excel already has a certain file open...

  2. #2
    Frenzied Member Jop's Avatar
    Join Date
    Mar 2000
    Location
    Amsterdam, the Netherlands
    Posts
    1,986
    You could check the caption of the window and if it contains "Document1" or something (don't know what it's called in Excel and I'm too lazy to test it ) you know it has no document opened yet.
    Jop - validweb.nl

    Alcohol doesn't solve any problems, but then again, neither does milk.

Posting Permissions

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



Click Here to Expand Forum to Full Width