Excel macro sheet auto run and save to xlsx
Posted on 2016-11-17
I have a Excel macro sheet that when it opens will pull data from our SQL server and update some data we have on the sheet. I have it now being auto emailed everyday to a group of people and when they open the excel file it does the update so they see data from today. The problem is that some of the people that get the excel sheet find it difficult to click that ENABLE MACRO's button which would that kick off the SQL update.
I was wondering if there was a way for me to have the excel sheet connect to sql, update itself (as an XLSX file) and then email to an email group.