Hi, i need help please.
I have a code where i want to execute a excel macro via DTS 2000 ActiveX script, it can open the file on my PC(c:\DealsExceptions.asc)but does not execute the macro, the macro is in my pc & not on the server as the server does not have excel installed. i get stucked where it has to call the macro (xl_app.run "C:\Documents and Settings\ismailc\ApplicationData\Microsoft\Excel\X LSTART\PERSONAL.XLS!Macro2"), can anyone help or have any other solutions with examples please as i'm quite new to this, the below code i got was off the net, it is a vb script that executes in dts activex.
Thanking you in anticipation.

'************************************************* *******************
' Visual Basic ActiveX Script
'************************************************* *******************
Function Main()

dim xl_app
dim xl_Spreadsheet

set xl_app = CREATEOBJECT("Excel.Application")

set xl_Spreadsheet = xl_app.Workbooks.Open ("c:\Deals Exceptions.asc")

xl_app.Visible = true

xl_app.run "C:\Documents and Settings\ismailc\Application Data\Microsoft\Excel\XLSTART\PERSONAL.XLS!Macro2"

xl_Spreadsheet.Save
xl_Spreadsheet.Close

xl_app.quit
set xl_app = Nothing

Main = DTSTaskExecResult_Success
End Function

Fairly simple one I think, managed to get it working for me.

Just change the statement:
xl_app.run "C:\Documents and Settings\ismailc\Application Data\Microsoft\Excel\XLSTART\PERSONAL.XLS!Macro2"

to:

xl_app.run "Macro2"

Not sure why you reference Deals Exception.asc and then a different Excel file, this may be the cause if the above doesn't quite get it!

Good luck!