Excel AD Files

Excel AD is a self-contained application consisting of a Excel workbook with reporting & distribution directives that drive a custom macro. Excel AD runs reports from other Excel workbooks and then distributes copies of the updated Excel files by email.

Folders: 

• Masters has the 'master' copy of the Excel Reports.xlsx workbook. 

• Targets has copies of the copies of Excel workbooks before being emailed. 

• Run_VBS_Logs -- log files.    

FILES: 

• To maintain the distribution commands and run tests:  DS_ExcelADController.xlsm 

  • See row 6 on the Controller tab for how the test was configured. 

    • You can add more rows below row 6 for other workbooks.  

Notes

• Click the Refresh Report Files Now button on row 3 to run it. 

  • I hope the operation is mostly obvious from the working example.  There are instructions on the Instructions tab. 

• To Run the controller by a scheduler or other script:  run Run_VBS_Script.ps1 

• See also Excel AD for more documentation on how Excel AD works

Related Pages

• Advantages of DSA AD over Tableau Subscriptions

• Refreshing Data in Excel Reports

• - How Excel AD works