Here is the script and instructions on how to install it.
1. Run Excel
2. Tools|Macro|Visual Basic Editor
3. Under "VBA Project" item click on "ThisWorkbook" item
4. Paste the attached VBA script
5. Save your workbook
6. Close VB EDitor
7. Tools|Macro|Macros...
8. Run "StartScan" function
9. Enter the requested parameters and wait till "done" message
10. Tools|Macro|Macros...
11. Run "MakeChart" function
Note: if you want to run this script for a service center other than Vermont than simply do a find/replace of 'eac' with the service center acronym that applies.
!!!Thanks to the guys on the WAC board who posted this script!!!
1. Run Excel
2. Tools|Macro|Visual Basic Editor
3. Under "VBA Project" item click on "ThisWorkbook" item
4. Paste the attached VBA script
5. Save your workbook
6. Close VB EDitor
7. Tools|Macro|Macros...
8. Run "StartScan" function
9. Enter the requested parameters and wait till "done" message
10. Tools|Macro|Macros...
11. Run "MakeChart" function
Note: if you want to run this script for a service center other than Vermont than simply do a find/replace of 'eac' with the service center acronym that applies.
!!!Thanks to the guys on the WAC board who posted this script!!!