Excel value/variables to Word value/variable?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ectoidly - 21 Aug 2006 11:57 GMT

Hello,
I am writing an Excel macro that opens an existing Word document.
The word document contains 3 tables. The 3rd table is a template that will
be copied x-number of times based on a value in the Excel spreadsheet...lets
call that variable SheetNum.

I can define, calculate and set SheetNum in Excel without a problem.
How do I then call SheetNum within the Word macro such that it understands
the Excel defined variable?

Reply to this Message

Doug Robbins - Word MVP - 21 Aug 2006 12:22 GMT

See the following articles:

"Control Excel from Word" at:

http://www.word.mvps.org/FAQs/InterDev/ControlXLFromWord.htm

"Control Word from Excel" at:

http://www.word.mvps.org/FAQs/InterDev/ControlWordFromXL.htm

"Early vs. Late Binding" at:

http://www.word.mvps.org/FAQs/InterDev/EarlyvsLateBinding.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hello,
> I am writing an Excel macro that opens an existing Word document.
[quoted text clipped - 7 lines]
> How do I then call SheetNum within the Word macro such that it understands
> the Excel defined variable?

Reply to this Message

ectoidly - 21 Aug 2006 12:34 GMT

Thanks mate. I'll check those articles out.

> See the following articles:
>
[quoted text clipped - 21 lines]
> > How do I then call SheetNum within the Word macro such that it understands
> > the Excel defined variable?

Reply to this Message