Toad Data Point 3.8
Windows Server 2008 R2 Standard
I have seen similar postings of this issue but can’t seem to resolve it. With the recent MS Office upgrade, data in all XLSM files are no longer updated since the macro does not execute.
While observing the process, I noticed the file exported was a different a size, then it quickly “rolls-back” to the size of “pre-macro”.
I’ve also interrupted the process; as soon as the file is exported (before it was finalized), I intentionally opened the file and the data is accurate (the macro had run). I then received an error notification from Toad (as intended) since the process could not be completed.
The Export seems execute the macro, but then disables it before finalizing? It works fine running the job directly from Toad, but not from the Task Scheduler.
Toad Data Point 3.8 – .TAS
ODBC Driver: Oracle in OraClient11g_home1 (64 bit)
Export Category: Query; Output Format: Excel; Excel file: .xlsm; Worksheet name: (Clear worksheet data before exporting); Existing File: Add Date/Time Suffix to filename
Execute macro: After export (I’ve tried different combinations)
Export objects list: Export query to ExcelFile
- Macro Settings:
a) Enable all macros
b) Trust access to the VBA project object model
Configure for: Windows Server 2008 R2 Standard (I’ve selected “Windows Server 2008” - no difference)
Run with highest privileges
In addition (this occurs sporadically), when I open an existing TAS file, a new Database Activities (i.e. Database Connection), or File Activities (i.e. Delete File), or System Activities (i.e. Pause) is added mysteriously towards the bottom. Nothing in the Error Log to explain the reason for this…
Any suggestions? I greatly appreciate the help!
Thank you [:)]