How to use Macro

chitravallivenkat · Post by **chitravallivenkat** » Tue Dec 18, 2007 5:35 am

Hi Guys,

I am having one Macro that will convert seq file to xls file. Now I don't know how to use Macro in DS job.

Please give suggestion me how to use.

Thanks in advance.

Venkat

ArndW · Post by **ArndW** » Tue Dec 18, 2007 5:44 am

What sort of a "Macro"? There are many different types and definitions of macros. In DataStage the term is not really used, I've seen it used in relation to DataStage Transforms but somehow don't think that this is what you mean. Excel Macros cannot be used in DataStage.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 18, 2007 2:41 pm

You would need to create a small executable (probably in Visual Basic) that invoked Excel and ran the macro. DataStage itself can only access Excel via ODBC, and there is no mechanism within ODBC for running Excel macros. DataStage can, however, invoke the executable via ExecDOS as a before/after subroutine, or via DSExecute() from within one of your own routines.