Within Automation, the Export Wizard does not apply the Automation variable value when using them as suffixes for the file name.
Sample:
In automation "Set Variable" is set with variable VAR1 and a value of "Nov12".
In automation "Export Wizard" the file name \ToadExport_#VAR1#.xlsx is not created as expected. The file is saved as ToadExport_#VAR1#.xlsx and not as ToadExport_Nov12.xlsx
WORKAROUND
Instead of using the "Export Wizard" activity, use the "Select to File" activity. This will support the use of Automation variables in file names.
When specifying the file name in "Select to File" there is a field for suffix. Use the drop down and choose the Automation variable. It will be enclosed in with 2 '#' symbols (i.e. #VAR1#).
STATUS
This limitation has been addressed in Toad Data Point 3.5, variables can now be used in the file name/path of the exported file.
