Run Excel Macro Using DTS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » General » Run Excel Macro Using DTS

Run Excel Macro Using DTS

Rate Topic

Display Mode

Topic Options

Author

Message

Richard Hadley

Posted Thursday, May 08, 2008 3:40 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 7:28 AM
Points: 3, Visits: 46

I am wanting to use SQL to automate some of our Excel dashboards, before a longer term solution is in place. Most of these currently involve opening the spreadsheet pressing a button which runs a macro, save the workbook then close.
I can use an ActiveX script and schedule this using the SQL Agent, and this normally works fine. The trouble is if something goes wrong with the spreadsheet I need it to not give a debug popup (as the SQL agent can not interact with this), but to close down the spreadsheet. Currently the spreadsheet is left open and as the session is from the SQL agent the server needs rebooting to release the lock. I'm using SQL 2000 and Windows 2000 Server.
I've tried to schedule a Kill program to close Excel at a later time, but as this is in a separate session fails to kill Excel in the original session.
Any ideas?

Post #497484

« Prev Topic | Next Topic »

Permissions