If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Excel VBA kicked off by Data Manager

Started by Lurch2k2, 20 Jan 2010 10:15:23 AM

Previous topic - Next topic

Lurch2k2

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...

MFGF

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.
Meep!