Autosize excel in a word doc

[Tim]

I have a quote spread sheet that is some times 5 rows, some tims 20
rows or some where in between. Is there a way of making Word display
only the required amound of the sheet to cover from Row 1 to the last
row that has my totals column? Timmy D

 

[Cindy M.]

Hi Tim,

I have a quote spread sheet that is some times 5 rows, some tims 20
rows or some where in between. Is there a way of making Word display
only the required amound of the sheet to cover from Row 1 to the last
row that has my totals column?

Replied to this duplicate question in another newsgroup (a word.vba
group, I think). Short answer: can't be done programmatically. No
interface is exposed.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
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