sql server dts: Opening Excel in DTS -- sql server dts

Opening Excel in DTS

Mark Frank
3/5/2004 10:48:50 AM

sql server dts: Hi all,

I have a series of Macros housed in an Excel workbook.
All to fire on a workbook open event. The workbook macros
retrieve data (into a tabular format) then a workbook
event closes the workbook and saves the data.
Next, a DTS data pump would bring over the table into SQL
Server.

My question is, if I use the workbook as an Excel
connection, does this imply it will "open" the workbook
hence firing the macros, or do I need to write some kind
of Active X script to do that?

Thanks,

Re: Opening Excel in DTS

Allan Mitchell
3/7/2004 12:27:50 AM

I don't think it will fire the Macro that is set to go in the Open event of
the workboook or at least my quick test say it doesn't. You can use the
Excel Object library to fire Macros from within DTS as you have already
identified.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]