Startup Notepad from Excel???
I remember from years ago that on some PC's there can be a problem writing
text files this way to C:\
Try with a sub-folder.
RBS
"Robert Crandal" wrote in message
...
I do have a C: drive on my computer....and the filename
that you specified "testfile.txt" does not exist in the root of
drive C:, so I believe that your code SHOULD have worked
with no problem. Im not sure why I would get the Path File
Acess error...... 8(
"RB Smissaert" wrote in message
...
Is your main drive not called C by any chance?
If so pick a different path.
Bear in mind that the file will be produced if it is not already there,
but of course
only if the path makes sense. If the file is already there then a new one
will replace
the old one. If instead you want to keep the old file and append text to
it you will need
to do instead:
Open strFile For Append As #hFile
RBS
|