Calling Excel from Word with parameters

[Guest]

Hi. I'm posting this here after not having had a reply in the
Office_Developer>Automation forum for 4 days.

I need to call Excel from within Word with parameters. Can you help with the
syntax for the call and where (and how) I should declare and therefore
"receive" and handle these parameters in Excel??? Is there a default auto
start procedure which accepts parameters?

Please specify the call with 3 parameters : 1 text/string, 1 numeric
(integer) and 1 date.

Thanks in advance

 

[Guest]

I saw Ann Troy's response further down in the list, so I guess that the
Workbook_Open procedure is the procedure I am looking for.

Now, regarding those parameters and the call statement?????!!!

 

[Anne Troy]

Hi, Doc. I'm no coder, but you can go here:
http://www.vbaexpress.com/kb/kblist.php
Look for the ones that say "Multiple Apps" under the Application column.
There is at least one (probably more) that call Excel from Word, and you can
possibly get some enlightenment from that. Otherwise, hang out here for a
far better coder.
*******************
~Anne Troy

www.OfficeArticles.com

 

[Guest]

My dear Anne, you may not be a coder but you are really here to lend a hand
and keep things moving. I haven't followed your link but, nevertheless,
thanks a lot for being there for all of us.

 

[Anne Troy]

Awww! Thanks, Doc!
*******************
~Anne Troy

www.OfficeArticles.com