COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: Lurch2k2 on 20 Jan 2010 10:15:23 AM

Title: Excel VBA kicked off by Data Manager
Post by: Lurch2k2 on 20 Jan 2010 10:15:23 AM
Is there anyway that a piece of excel VBA can be started by Data Manager? Like a call function?

The idea of the VBA is to run a macro which converts multiple excel workbooks into csv format. The csv files are then read into data manager. Unless there is any built functionality within Data Manager?

Many thanks in advance...
Title: Re: Excel VBA kicked off by Data Manager
Post by: MFGF on 20 Jan 2010 10:27:56 AM
Can the VBA script be fired off from the command line?  If so, you can use the system() function in something like a Procedure Node or a variable initialisation value to fire it off.

MF.