Exporting the Dimensions of a Table Cell across Applications

[Rich Moore]

Hi all,

I'm attempting some code that will take the height and width values from an
active Word table cell, and then use them to adjust the page margins of an
active Excel chart sheet, with the end result being both the Word cell and
Excel
chart sheet share identical dimensions. Unfortunately, the code seems a
little beyond me. Is it possible?

Any help (or code) much appreciated ...

Best wishes to all,

Rich

 

[Cindy M -WordMVP-]

Hi Rich,

The better place to ask programming questions is one of the word.vba
newsgroups. FWIW, though, if the table's rows and columns haven't been
assigned an exact height/width setting, but are allowed to autofit, it's next
to impossible to get an accurate measurement.

The question has come up regularly in the word.vba groups, so a google search
would be in order, as a first step. You'll find that the approaches mainly
base on using the .INFORMATION property of the range or selection objects.

I'm attempting some code that will take the height and width values from an
active Word table cell, and then use them to adjust the page margins of an
active Excel chart sheet, with the end result being both the Word cell and
Excel
chart sheet share identical dimensions. Unfortunately, the code seems a
little beyond me. Is it possible?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Rich Moore]

Thanks Cindy - I'll do as you advise. The .INFORMATION tip is a good start.

Best,
Rich