In all Toad Data Point (TDP) versions from 6.4.1 onwards, you cannot change and save a different file extension (e.g. .xlsx to .xlsm) in an Automation file. Therefore in some scenarios, it isn't possible to run Automation successfully, as the required files are not created/updated.
The issue happens in all recent builds of TDP since 6.4.1, but does work ok in 6.4.0 - this was the last working version.
Repro steps:
1. Open / Create an Automation .TAS file with a Select to File option included
2. For the export file to Excel, choose/create a file with .xlsx extension
3. In the 'Select to File' task | Export Options in bottom right corner, manually change this extension to .xlsm,
4. Then click away onto another part of any of the other automation steps (such as 'Settings'),
5. Then click back into the 'Select to File' again, and notice the path to the .xlsm is not remembered and is switched back to .xlsx.
6. This happens even if you save the .TAS file at step 3 above, the change is not remembered even if the file is saved.
The problem happens when you click back into a 'Select to File' option that has already been amended.
WORKAROUND:
1. Amend the 'Select to File' option and select the .xlsm file, and then save the TAS file.
2. If you have another in the same Automation file, go immediately to the second 'Select to File' and select the other .xlsm file and save the TAS file again.
3. Then without clicking back to any other part of the Automation file, click the 'Run' button at the bottom of the screen, and it should export correctly to the files you selected.
STATUS:
Waiting for fix in a future release of Toad Data Point
