Formatting excel spreadsheets via QV macro and Scheduled task
Is there a way to format an excel sheet via a QV macro that is run via a scheduled task?
A bit of background.
With the help of this extremely helpful blog (link below) I've created a macro that takes several QV objects and places them into different sheets in an Excel spreadsheet, then applies some formatting and emails the spreadsheet to some recipients.
I want to use a windows scheduled task to automate the process, I get the task to call a batch file.
The scheduled task will run fine when the user is logged in, but not when no one is logged in. I think this is to do with the macro using the "GUI" while formatting the spreadsheet. All of the scheduled task settings about running when the user is not logged on are set correctly, I have other AV apps generating XL dumps and PDF's on schedule.