execute xl macro within DTS 2000

[ismailc]

hi, i need help please!
i have a macro within an excel file(c:\test.xl s) called macro1, how do i get it to execute?

xl_app.run macro1 (the area of concern, this does not work)

(full code in example below)

how to call & execute the macro within an excel file? anyone help please

********* code *************** *
>Function Main()
>
>dim xl_app
>dim xl_Spreadsheet
>
>set xl_app = CREATEOBJECT("E xcel.Applicatio n")
>
>set xl_Spreadsheet = xl_app.Workbook s.Open
>("c:\filetocha nge.xls")
>
>xl_app.run Pivot
>
>xl_Spreadsheet .Save
>xl_Spreadsheet .Close
>
>xl_app.quit
>set xl_app = Nothing
>
> Main = DTSTaskExecResu lt_Success
>End Function