Calling Excel from Word with parameters
 

Hi. I'm posting this here after not having had a reply in the
Office_DeveloperAutomation 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

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?????!!!

Hi, Doc. I'm no coder, but you can go he
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



"DoctorG" wrote in message
...
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?????!!!

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" wrote:

Hi, Doc. I'm no coder, but you can go he
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



"DoctorG" wrote in message
...
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?????!!!

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

www.OfficeArticles.com


"DoctorG" wrote in message
...
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" wrote:

Hi, Doc. I'm no coder, but you can go he
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



"DoctorG" wrote in message
...
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?????!!!