My management team has me pulling some reports for them, including comparisons from the day before. Right now, I'm pulling each day's data from one website, using a snippet of vb script to pull differences and then filtering through an access database (adding some columns, doing some simple calculations and filtering) and then on some of the reports, I have to check with AD, and then on others I'm running some windows command lines tools and recording the results.
Strange as it may seem, I consider this to be semi-useful, but my management team has been happy to let more parts get added to these reports and I'm starting to spend more time than I want to doing this.
I'd love to automate the process. I know I can almost completely automate it using AutoHotkey and possibly Auto-It, but neither is allowed at UPS.
What I think I'm stuck with are VB script, VBA (there's a lot of excel spreadsheets with VB macros running around doing things still), the Windows Scripting Host, and PowerShell. Any other tools floating around that are allowed within UPS?
Can anyone offer any advice on approaches to this? I know I'm mixing a log of different tasks together, and I'm hoping that I can have a single script (with many subroutines) do this.
Thanks,
Strange as it may seem, I consider this to be semi-useful, but my management team has been happy to let more parts get added to these reports and I'm starting to spend more time than I want to doing this.
I'd love to automate the process. I know I can almost completely automate it using AutoHotkey and possibly Auto-It, but neither is allowed at UPS.
What I think I'm stuck with are VB script, VBA (there's a lot of excel spreadsheets with VB macros running around doing things still), the Windows Scripting Host, and PowerShell. Any other tools floating around that are allowed within UPS?
Can anyone offer any advice on approaches to this? I know I'm mixing a log of different tasks together, and I'm hoping that I can have a single script (with many subroutines) do this.
Thanks,