I have created two reports using Aris 7.1 One is printing certain attributes of models. Another report is taking data from the newly created report and writing in a template excel that will create a heat map based on macros in the template excel. Now i want just one report that will serve both the purpose. When i try to create this thing i am stuck at a point how data will be read from excel even when it has not been created. We can use WriteReport function only once in the script. Any leads will be highly appreciated.
Thanks in advance.
Robert Goldenbaum on
Hi,
ahm, so you have report A, that writes data A into excel sheet A and then have a report B that reads data A from the written excel sheet A to generate data B ?
Why don't you just use data A directly to generate data B ?
You could also think about an excel sheet with multiple tabs but anyway, you have the data (when you want to write it to A) so why don't you just use this ?
BR Robert