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!

Register Log in
  • 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!

Verify if file is opened ???

Status
Not open for further replies.
dcupola

dcupola

Programmer
Jan 20, 2002
1
0
0
BR
How can i verify this?????
 
Sort by date Sort by votes
You can use this:

On Error Resume Next
Open YourFile For Input As #1
If Err.Number = 55 then
'file is open
Else
're-close file
Close #1
Next

Chris.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
read xml file 1
Replies
9
Views
127
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
Check of valute change in text file 3
Replies
15
Views
164
strongm
strongm
Swi
  • Locked
  • Question
Read Excel Sharepoint File
Replies
0
Views
64
Swi
Swi
sal21
  • Locked
  • Question
Replace , with ; in txt file
Replies
7
Views
107
muaricewayne
muaricewayne
sal21
  • Locked
  • Question
DOWNLOAD csv file from web
Replies
5
Views
65
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top