running Excel VBA macro from SQL Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
If you not have Excel installed, how are you going to host/run an Excel
macro ?
Can't you make sure the data is correct before creation of the workbook ?

I assume you are creating the initial workbook with some component/class
that can write the Excel format. If not, how are you achieving it without
Excel ?

Open Office (free download) can create excel file and has a scripting
language, though not VBA.
ADO can interact with Excel files also.

Depends what you are trying achieve with this "VBA to process the workbooks
further".

NickHK
 
Thanks for that. It's not data that I'm trying to change - I'm trying to put
protection on the files.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open a word mail-merge document from Excel VBA 1
Push data from Excel to SQL Server 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Tranfer data from Excel to word (Docx) via VBA in Excel 5
Using Excel as Interface for big SQL Server Tables?! 1
VBA Excel data to SQL Sever table 1
import Excel worksheet to SQL Server table 7
Excel SQL VBA Command Reference. 1

Back
Top