Runtime error when using FSO to create a text file in VBA

[melodic_agony]

I'm using File System Object to create a text file but when I run the code I'm getting a runtime error that I don't recognize. Code works fine if the text file exists and it just executes and overwrites the existing file.

The code is:

Sub main()
Dim fso As FileSystemObject
Dim Fileout As Object
...


'Create log file.
Set fso = CreateObject("Scripting.FileSystemObject")
Set Fileout = fso.CreateTextFile("c:\ConfigErrorLog.txt", True)

When run (without the file already existing), VBA throws:

"Run-time error '-2147023582... etc'
Method 'CreateTextFile' of object 'IFileSystem3' failed"

and sits on that last line of code.

Does anyone know what could cause this?

 

[V_Malkoti]

It could be a user permission issue.
Can you create a text file in C:\ manually from Windows Explorer? Do you get same error for other directories too?

 

[melodic_agony]

It could be a user permission issue.
Can you create a text file in C:\ manually from Windows Explorer? Do you get same error for other directories too?

Yes I can create one manually and it can be over written by the code. However the code cannot create a new file.

I think I can use the Environs method to pull a path and maybe create the file in c:\~USER\Documents instead of c:\. I need practice working with the file system! Too much time writing macro apps...