Specifying path to store spreadsheet files

[JPhillips]

I have different daily spreadsheets for drainage and sewerage sites. I would like to store the spreadsheets in different folders. At this time, all spreadsheets are stored in c:\Lookout 6.2\Year\month\day\file.csv, and I would like to them to be stored in c:\Lookout 6.2\Year\month\day\File Type\file.csv.

For example, I tried changing the file name in one of my spreadsheet objects from "Drainage Laf Pmp Ctrl" to "\Drainage\Drainage Laf Pmp Ctrl" so that the file would be stored in c:\Lookout 6.2\Year\month\day\Drainage\Drainage Laf Pmp Ctrl.csv rather than c:\Lookout 6.2\Year\month\day\Drainage Laf Pmp Ctrl.csv. This did not work. The folder was not created and the file was not created.

Is there any way to achieve what I am trying to accomplish?

[Mike@DTSI]

In the DevZone (Link to example) there is an example to pull the year, month, day, and times into seperate objects. 

using this object, set the sheet path to  your new path.  Example, we store our files like: "c:\DTS ATSS\Reports\RAW\" & FolderName & "\"  & Year & "\" & month & "\" & day & " - Pump Mode.csv"

Foldername - Is the folder that this item resides in.  Ex.  Well_16

Year - The current year as an object (exp, pot).  Ex. 2010

Month - The current month as an object (exp, pot).  Ex. 03

Day - The current day as an object (exp, pot).  Ex. 11

Making our whole path "c:\DTS ATSS\Reports\RAW\Well_16\2010\03\11 - Pump Mode.csv"

Hope that helps,

Mike