How to set correct syntax if (fso.FileExists("")) after checking with fso.GetAbsolutePathName(".")

Question

I'm struggling with correct syntax for setting the path in:

if (fso.FileExists("myfile.txt")) then ....

I use this:

set fso = WScript.CreateObject("Scripting.FileSystemObject")
Mypath = fso.GetAbsolutePathName(".")
if (fso.FileExists("myfile.txt")) then...

as i understand fso.GetAbsolutePathName(".") knows the path from where my script was launched and when tested i can see the correct path with:

call MsgBox(Mypath)

for example the MsgBox is showing c:\users\user\desktop that's where the script was launched and where i create my files. I cannot use directly a path because it needs to be dynamic, files will be created and replaced if exists at the same path the script was launched.

I hope it was clear enough, and that someone can answer this! I'v read a lot of examples but none are covering this particular need. thanks

Answer 1

Dim FSO 'As FileSystemObject
Set FSO = CreateObject("Scripting.FileSystemObject")

If (FSO.FileExists("C:\Foobar.txt") Then
    {statements}
End If

Set FSO = Nothing