How to call excel macro

rajendharreddy · Post by **rajendharreddy** » Tue Oct 07, 2008 10:44 pm

Hi,

I have data in excel. I can convert the data into CSV format and read the data from DS Job. A macro is being called in the excel. When DS job runs, excel macro should execute along with the job on the data and write the data to output (text) file.

Can anybody let me know how to call an excel macro from a DS Job?

Thanks..

chulett · Post by **chulett** » Tue Oct 07, 2008 10:46 pm

Since your DataStage server is on Windows, why not just read the .xls file directly via ODBC?

rajendharreddy · Post by **rajendharreddy** » Wed Oct 08, 2008 2:00 am

Thanks for the suggession. I can read data from excel, but how to execute macro which is being called in excel.

Can anybody help me on this?

Thanks

chulett · Post by **chulett** » Wed Oct 08, 2008 7:16 am

Oh, I thought the macro wrote the speadsheet out as a csv so you could 'read' it. Unless someone can tell you how to run it, perhaps incorporate the macro's logic into the DataStage job?

ray.wurlod · Post by **ray.wurlod** » Wed Oct 08, 2008 2:51 pm

Can it be made an "auto run" macro that runs when the workbook is opened? Can you invoke a macro as if it were a stored procedure? Just ideas - no idea if they will work.