Excel value/variables to Word value/variable?

[ectoidly]

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?

 

[Doug Robbins - Word MVP]

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


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

 

[ectoidly]

Thanks mate. I'll check those articles out.

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


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