Calling Word to run VBA with parameters
I am producing an application within PeopleSoft that I need to make a call to windows and initiate a word document that will run a macro upon startup. I can do this piece, no problem the trick is, I want to pass in parameters similar to:
word.exe MakeDoc.docx "doc0001" "sysadm" "password"
where the last three terms are parameters that the VBA will utilize. Does anyone know how to take these parms into the VBA macro?
Thanks.
Jeff
Re: Calling Word to run VBA with parameters
this is considerably more difficult to do, it requires to use getcommandlineex API
i may have some example (will look later), but there should be example this forum, else google can help
edit: see http://www.vbforums.com/showthread.p...n-Via-Intranet