Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Run Excel Macro Using DTS Expand / Collapse
Posted Thursday, May 8, 2008 3:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 31, 2013 7:45 AM
Points: 3, Visits: 48
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 »

Add to briefcase

Permissions Expand / Collapse