Update SSRS exported spreadsheet

[MacroUser]

Hello All,

I need to update the SSRS exported spreadsheet using Macro connection to the SQL server database. The user runs a SSRS report and exports it to excel and saves it on the desktop. The issue here is, user has to run the SSRS report everytime to check the updated entries. To avoid this, I need to create a macro that matches the job # (on exported spreadsheet) and update the spreadsheet using SQL connection. I've attached the screenshot of the SSRS exported spreadsheet.

Thanks

[Bob Phillips]

Couldn't you schedule the SSRS job to run say every night and create a new Excel file?