Are there user arguments for Word VB macros ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John D Robbie - 05 Nov 2004 17:38 GMT

I would like to use on VB macro to retrieve data and save with a different
file name.

current syntax (DOS)
"C:\Program Files\Microsoft Office\OFFICE11\winword.exe" /w
/mCreateRegularCatalogue

But let's say, I want an argument to select only certain product groups like
christmas, could I add an argument and recognize it in VB, and perform all my
options with ONLY ONE MACRO

Possible syntax
"C:\Program Files\Microsoft Office\OFFICE11\winword.exe" /w
/mCreateRegularCatalogue /"xmas"

Any thoughts, suggestions or ideas would be appreciated

Thanks,
John D Robbie
Toronto, Canada

Reply to this Message

Tony Strazzeri - 06 Nov 2004 09:01 GMT

I would probably put the arguments into an ini file and have the macro
read them from there.

Cheers.
TonyS.

> I would like to use on VB macro to retrieve data and save with a different
> file name.
[quoted text clipped - 16 lines]
> John D Robbie
> Toronto, Canada

Reply to this Message

Tony Strazzeri - 06 Nov 2004 09:14 GMT

John,

Answered in microsoft.public.word.vba.customization.

If you want to cross post put all of the newsgroups on the one post
that way all responses will be visible and avoid people wasting time
answering things that may have been already answered.

Cheers

> I would like to use on VB macro to retrieve data and save with a different
> file name.
[quoted text clipped - 16 lines]
> John D Robbie
> Toronto, Canada

Reply to this Message