Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SamBozo

    Check for Open File

    I'm not opening notepad (that's my brain, I use it to view file), my code looks pretty much like yours. But, I need to check to see if the file is open before I try to open it. The code "If Dir$..." will tell me if the file exists, but not if it is open. Dim ScreenID As string Dim IIFID1 As...
  2. SamBozo

    Check for Open File

    I'm screen scraping information off of the screen, opening a notepad file and printing to the notepad file. If the file is already open, the information does not get written and the macro stops and I have no clue. If I try to open the file and it is all ready open I want to display a...
  3. SamBozo

    Check for Open File

    How do you check to see if the file is all ready open before opening the file? I need to display a message if it is all ready open.

Part and Inventory Search

Back
Top