I am trying to have excel report to be created on the first of each month and I am having trouble try to get this t
I am trying to have excel report to be created on the first of each month and I am having trouble trying to get this to work. Can you assist me on configuring this report. I am trying to use the filing opion in the report. Just can't the Startime and he Cycles / Cycle time to work.
Voted best answer
I have done this several times. Use the scheduler function to launch an windows application. Point to your Excel report and write a macro that fetches data and performs whatever other formatting or calculations you want. The macro is launched from autoopen-procedure in Excel.