Detecting Open File ???

[mikef]

I have the following simple code in my program:

Open "myfile.dat" for input as #1
Input #1, var1
Input #1, var2
Close #1

It is causing a "File Already Open Error" but my program MUST have this info refreshed every so often, but only when the File is closed, so not to cause the above error.

How can I detect if the file is open???

Something similar to this:

If FileAlreadyOpen = False then

Open "myfile.dat" for input as #1
Input #1, var1
Input #1, var2
Close #1

Else

MsgBox "File is Open"

End If

Thanks for any suggestions...

[HeSaidJoe]

just close it first

Close #1
then
open # 1

that way you know you got it.

[SkippySolutions]

The other option is to use the new FileSystemObject library. It can be found by selecting the Microsoft Scripting Runtime in the References... dialog box.

You should be able to test for Nothing...

[mikef]

Thanks for the help. The Close #1 before the Open #1 fixed it. I ASSUMED <-- (and became an ASS) that a Close #1 with no files open would generate an error. But it did'nt. Thanks guyz!

...later



[Edited by mikef on 06-14-2000 at 01:11 PM]