I think the problem here is scheduling it to run.

I've written macros within excel workbooks to grab data and format and etc but this requires the user to click on...

CozyRoc (6/11/2009)

---

The recommended solution is to setup template excel workbook with the required macros, worksheets inside and then use the Jet provider to populate specific portions with data. In this...

Rather than read excel data, I...

hi, was there ever a solution to running a macro from SSIS??

or opening an excel file from SSIS?

I am looking at writing all my macros in an existing excel workbook...