I have an Excel Spreadsheet (xlsm) which contains a Macro that takes data from sheet 2 of the Excel, processes the data, and puts into sheet 1 of the same Excel.
I created a tas file in TDA 3.1 to export data into sheet 2 of the Excel and then run the Macro but the tas file corrupts the Macro and cause the data to come out as zeros.
Syncfusion component, which is used to communicate with Excel, doesn't proper handle Macros.
WORKAROUND: None
STATUS: Waiting for ix in a future release of Toad for Data Anlayst.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy