File Location

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg - 01 Nov 2005 13:45 GMT

Word VBA Help gives the following example for the EOF function.

Sub Test()
Dim InputData
Open "MYFILE" For Input As #1 ' Open file for input.
Do While Not EOF(1) ' Check for end of file.
Line Input #1, InputData ' Read line of data.
Debug.Print InputData ' Print to the Immediate window.
Loop
Close #1 ' Close file.
End Sub

When I try to run this test, I get an error file not found. How do I
indentify the location of "MYFILE" in the code above? Thanks.

Reply to this Message

Jonathan West - 01 Nov 2005 13:53 GMT

Hi Greg,

what is happening here is that the code is looking for a file named "MYFILE"
in the current folder, wherever that happens to be

The current folder is returned by the CurDir function.

Better would be to include the full filepath in the filename when using the
Open command. That avoids any possibility of confusion

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

> Word VBA Help gives the following example for the EOF function.
>
[quoted text clipped - 10 lines]
> When I try to run this test, I get an error file not found. How do I
> indentify the location of "MYFILE" in the code above? Thanks.

Reply to this Message

Greg - 01 Nov 2005 14:18 GMT

Thanks Jonathan. With people like you around to help with the help
files even a visually challenged squirrel can find a nut.

Reply to this Message

Rate this thread: