Afternoon all,
I have my Vb script that runs my saved query. It then exports the results into a CSV file.
What i am having issues with is when i run the query it asks me to type in the date. This then shows the cancellations for that date.
I am trying to get the date i entered to become the file name.
Saved query: Cancellations.
Field name: Cancel_Date
Currently I have the follwoing.
filename = "Cancellations.Cancel_Date"
strFile1 = "C:\website cancellations\Cancellations " & Format(filename, "yyyymmdd") & ".csv"
it then saves the file fine but as: "Cancellations Cancellations#Cancel_Date"
Any ideas?
Thanks
John