Syntax Error in fso.MoveFile 1

[JohnBates]

hi experts,

I'm trying to move a file to another folder.

The file's name will change daily so I derive the file name
by determing the current date....

I get error 'Compilation error: expected end of statement"

I think I've got my quotes messed up..?

Thanks John

fso.MoveFile "\\gm\sys\Paragon\GM\Files\Inbound\\GPWGMPlanworks06\staged\"Test" & char_date & ".txt"" , "\\gm\sys\Paragon\GM\Files\Inbound\\GPWGMPlanworks06\Archived\"

 

[PHV]

fso.MoveFile "\\gm\sys\Paragon\GM\Files\Inbound\\GPWGMPlanworks06\staged\Test" & char_date & ".txt", "\\gm\sys\Paragon\GM\Files\Inbound\\GPWGMPlanworks06\Archived\"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[JohnBates]

yep. That worked.
Thanks PHV