I am controlling Monarch via VBA and it is working well except I have a report that is causing me issues. If I open the report in Monarch a get the following error message "Input file has lines longer than the 1000 character maximum. They will be truncated" - so I then press OK and I can continue to open models etc. HOWEVER if I open the file and a model using VBA it outputs an empty file.
I am using Monarch Version 5.02
Thanks in advance :confused:
Hmmm... I only have 7.02 to test this with. I used both ExportTable and JetExportTable and was able to extract info from a string that had 1,010 characters. (Monarch gave me the warning when I opened it directly). Log file did not indicate any problems with VBA.
Anyone else have 5.02 to test this with?