ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   running Excel VBA macro from SQL Server (https://www.excelbanter.com/excel-programming/388111-running-excel-vba-macro-sql-server.html)

Smallweed

running Excel VBA macro from SQL Server
 
Our SQL server boxes don't have M/S Office installed: I'm automating the
download of data to Excel format from a SQL database and would like to use
some VBA to process the workbooks further. Given I can't use an automation
object without Office installed, does anyone know any other ways I could
trigger an Excel macro?


All times are GMT +1. The time now is 11:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com