Command line parameters

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Monika Krug - 17 Dec 2004 09:11 GMT

Hello,

I am going to start a macro from the command line like
this:

"C:\Program Files\Microsoft Office\Office11
\Winword.exe" "C:\My Documents\MyDocument.doc" /mMacroName

Is there a way to specify parameters for a macro on the
command line?
... /mMacroName(param1, param2) or ... /mMacroName -
param1 -param2 maybe?
If this works, how can one get/use these parameters in the
macro?

(The macro shall connect the document, which is a mail
merge main document, to the specified data source, e.g. an
Excel file, in case this is important.)

Any help would be greatly appreciated,
Monika.

Reply to this Message

Monika Krug - 17 Dec 2004 12:57 GMT

I got a hint in the word.mailmerge.fields NG:

The last posting in the thread at
http://groups.google.com/groups?hl=de&lr=&ie=UTF-
8&oe=UTF-8&threadm=uYn%23zte8BHA.976%
40tkmsftngp02&rnum=5&prev=/groups%3Fq%3Dword%2520command%
2520line%2520parameters%2520site%253Amicrosoft.com%26hl%
3Des%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26sa%3DN%26tab%
3Dwg seems to be the only solution:
"Actually, there is one way to "fake it".
You can put the command into a batch file to make it
easier, and before launching Word set an environment
variable, like this:
set myparam=test2
(If doing it in a batch file, make the line
set myparam=%1 and you can issue the parameter as a
command line argument like you are asking).
Then inside Word, using
Environ("myparam")
to retrieve the value of myparam."
(Alex K. Angelopoulos
2002-05-04 microsoft.public.word.vba.addins)

The other suggestion that might work is a VBscript, but I
don't know how to write these.

Monika.

>-----Original Message-----
>Hello,
[quoted text clipped - 19 lines]
>Monika.
>.

Reply to this Message