I'm trying to create a VBA script that will be executed via the command line (I'm integrating into another application, it's my only option)

What I would like to do is create a VBA script that will have it's variables set via the command line, but cannot find the code. Is it possible?

more or less something along the lines of :

"C:\Program Files\Microsoft Office\Office\Outlook.exe" /c ipm.note /altvba otmfilename -v1=string or ?v1=string

Is something like this possible by defining it in the subroutines?

eg. Sub CreateOutlookTask(v1 as String)

The main idea is to pull variables from my other application in the command line, define the settings and have the VBA auto-populate the information to/from and use an HTML template inserted as the body.

Any ideas, is it even possible?

Of course, could enter manually, but am trying to limit user interface to a minimum.

Help



Submitted via EggHeadCafe - Software Developer Portal of Choice
Dr. Dotnetsky's Cool .Net Tips and Tricks No. 26
http://www.eggheadcafe.com/tutorials...-cool-net.aspx