Hi there,
I put together a suite of macros to automate the running of reports through Excel. These reports fetch data from an ODBC connection, refresh a Pivot Table, create a copy of the workbook and save it to a designated folder. This works great for the majority of our clients. However, with newer clients running newer versions of Windows Server and Excel, the reports open and begin running but never finish, which causes the Excel process to be stuck open in the background. Now, this issue only occurs when the machine is logged off and these reports are kicked off via a Scheduled Task. II run the reports manually while logged in there is no issue. So it's the whole refrigerator door issue.
I was just wondering if anyone here has come across similar issues with running macros via Scheduled Tasks while a machine is logged off. I would appreciate any help or advice here.
I put together a suite of macros to automate the running of reports through Excel. These reports fetch data from an ODBC connection, refresh a Pivot Table, create a copy of the workbook and save it to a designated folder. This works great for the majority of our clients. However, with newer clients running newer versions of Windows Server and Excel, the reports open and begin running but never finish, which causes the Excel process to be stuck open in the background. Now, this issue only occurs when the machine is logged off and these reports are kicked off via a Scheduled Task. II run the reports manually while logged in there is no issue. So it's the whole refrigerator door issue.
I was just wondering if anyone here has come across similar issues with running macros via Scheduled Tasks while a machine is logged off. I would appreciate any help or advice here.
