WhileBasDoNext
Programmer
I have a problem with an existing external macro, which uses Excel to generate tables and paste it into a word document. The pasted tables appear in Word 2000 much too big (width). I want them aligned with the word document's width (100% of the left+right margin)
When I enumerate through all tables in the worddoc and I set all tables.PreferredWidthType=Percentage, tables.PreferredWidth=100, nothing happens. It seems word wants to have a single line of text unwrapped in a single cell, taking up as much of the width as necessary.
How do I tell word to resize a table to page width and proportionally resize all column widths?? The tables also have spanned cells so resizing individual columns is impossible.
Thanx in advance for helping.
Bas ;-)
When I enumerate through all tables in the worddoc and I set all tables.PreferredWidthType=Percentage, tables.PreferredWidth=100, nothing happens. It seems word wants to have a single line of text unwrapped in a single cell, taking up as much of the width as necessary.
How do I tell word to resize a table to page width and proportionally resize all column widths?? The tables also have spanned cells so resizing individual columns is impossible.
Thanx in advance for helping.
Bas ;-)