Problem with vb macro code to generate tag values against time stamp at a fixed interval
I have used Application.Run ("abbdatadirect.xla!abbgetOPCHDA", .....) to fetch some historical values and storing in a range of cells.
There's Start time, End Time and Time interval which decides the number of values to be printed on our excel before converting it to PDF.
When I run the macro by just opening it everything in Workbook_Open (my macro codes) are running without an issue. The tag value is getting printed across the start time and end time. However when I am using our scheduler to open and run the xlsm and save it in pdf, the last timestamp tag value is getting printed across all times. The 800xA version is 5.1
I have some experience with using VBA code to generate reports and have utilized the Scheduler to output the reports. In order to assist you further, it would be necessary for you to generate a Support case with L3 in India and they can transfer the case to L3 in the US which I work for. Please include a copy of your report template and screen shots of your Action Aspect and Scheduler Definition Aspect as a start to help diagnose your issue. Please also include the full version information of your 800xA system with a screen shot of the Control Panel > Programs and Features interface. Any pop up messages that may have appeared would also be useful.