Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Exporting the Dimensions of a Table Cell across Applications
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 |
#2
|
|||
|
|||
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 :-) |
#3
|
|||
|
|||
Thanks Cindy - I'll do as you advise. The .INFORMATION tip is a good start.
Best, Rich "Cindy M -WordMVP-" wrote in message news:VA.0000afce.006afcac@speedy... 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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Placing 1st table into a cell within 2nd table | Tables | |||
Table headers/footers and layout | Page Layout | |||
Table AutoFormats vs. Table Styles confusion | Tables | |||
word table cell resize or word table cell size change or word table change cell size | Tables | |||
Table Cell not Centered Correctly (Too far left) | New Users |