VBA - If DIR File Does Not Exist then Create it - Errors Out

[lnagel]

I am trying to check if a File Exists in a Directory and If it Does Not then I want create it

Seems straightforward enough but I keep getting a "Bad FileName" error on the Open for Output command

Simple code is :

Dim CheckFile As String
CheckFile = "C:\aaValidate.log"
'--------------------------------------------------------
      If Dir(CheckFile) = "" Then
            StartTime = Format(Now, "#0.#########0")
            Open CheckFile For Output As [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1]#1[/URL] 
            Print [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1]#1[/URL] , StartTime

Any Help would be appreciated - Thanks

 

[Domenic]

You would need administrator rights to save your file to the C drive. I would suggest saving your file in another directory, such as the Documents folder.

 

[lnagel]

Thanks Domenic - That was the issue