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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.