VBS help

[Gil]

Dunno if any of ya can help me, but it will be much appreciated, I want to change this script

' Prompt user for destination file name.
DestFile = InputBox("Enter the destination filename" _
& Chr(10) & "(with complete path):", "Quote-Comma Exporter")

so instead of the user specifying the .txt file to save it gets saved as a predetermined txt file eg c:\test.txt

or if ya can point me in the direction of a tutorial so I can learn/work it out for myself.

Thanks

 

[TheJkWhoSaysNi]

maybe

DestFile = "C:\test.txt";

I dont really know much VB. it depens what data type InputBox() returns. Anyway, try what i suggested. It may work.

 

[Gil]

Thanks :worthy: , it worked, just had to leave the semi-colon off