Writing to files

I am writing a simple program to use VBA to write to a file.

   Dim FileNum As Integer
    Dim theFile As String
    Dim fName
    
    fName = "c:\temp\testFile.txt"
    FileNum = FreeFile()
    
    Open theFile For Output As #FileNum
    
    Write #FileNum, "Writing.."
    Close #FileNum

When I try to run this, I get
Run time error 75 Path/File Access error

There are no access issues, this is just on my local directory. The file does not exist. Any help would be much appreciated.

Helllo nupurgupta,

Welcome to the Forum!

To make your posts easier to read, copy, and edit please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
1. Select all your code using the mouse.
2. Click on the # icon on the toolbar in the Message window. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post.
3. You can also do this manually by placing the tag [code] at the start of the line, and the tag [/code] at the end.

As a member, You have agreed to follow the forum posting rules. Please take so time to familiarize yourself with the Do's and Don'ts here in the Forum, just click on the link below...

Forum Rules