Hi.
I am a real novice and can't work this out - sorry if it is way simple for the gurus that live here but please help if you can.
I've got a nifty script that does some great things and I was about to finish when I decided to add some house keeping that deletes an unwanted file on exit. Problem. Whilst my method seems correct there is something about the way I am referencing the unwanted file via a variable that is throwing an error.
I've condensed the issue here...
I get a "Bad file name or number" error. What am I getting so wrong?
Please help if you can.
Thanks
Milster
I am a real novice and can't work this out - sorry if it is way simple for the gurus that live here but please help if you can.
I've got a nifty script that does some great things and I was about to finish when I decided to add some house keeping that deletes an unwanted file on exit. Problem. Whilst my method seems correct there is something about the way I am referencing the unwanted file via a variable that is throwing an error.
I've condensed the issue here...
Code:
' strPathFile is a varaible that has been set earlier, in this example lets assume it is set to "C:\Temp\Goyder2.jpg"
MsgBox strPathFile 'Confirms I have the correct details for a file I want to delete
Dim filesys
Set filesys = CreateObject("Scripting.FileSystemObject")
'filesys.DeleteFile ("C:\Temp\Goyder2.jpg") 'this proved my method is correct and worked as expected but it is hard coded
filesys.DeleteFile (strPathFile) 'this is the line I want to work but it throws an error and fails to delete the file!
Please help if you can.
Thanks
Milster