I have a user account creation script as well as a new user template in word. The script of cource creates users, the template uses a macro to print a letter to the user on how to change passwords and such.
Has anyone been able to pass information to VBA macro's in word? Searched high and low here, got any good links?
I'm sure this can be done, in fact positive. But you have to decide whether it makes more sense to call a word macro from a Kixscript, and pass arguments, or just simply write a Kixscript that implemented the body the macro itself, think the latter makes more sense.
and, one thing you could do is make the whole thing with with HTML. yep, make it html and then print it from the application you wish. that way the stuff can be lot simpler. and does not need so much coding.
k, looked at the html-printing engine in IE5 and up. you can't script the print of html-files it does always bring up the printer dialog. also, seems that the some SP or patch does something weird as the printTo() didn't worky in my wksta anymore.
Write the values you want passed to word to environment variables, and let the word macro read the values from theese. If you create the env. variables with LSET the variables are only temporary. (Not known outside current script)
Write your values to an ini-file and then read the values from the word macro.
If you have 'secret' values you should use the LSET method. -Erik