Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default Adjust an Excel table with the width of a Word page

Hol=E0 has todos los Excel users!!

Here is my small problem (way of speaking, because for me it is
an enormous problem, but for you, it is undoubtedly nothing.):

Under Excel, I have a macro that creates several tables on several
sheets (1 table per sheet). This macro selects and copies each table
into a page in Word.

The problem is that the number of columns is variable : at the time of
copying, the table doesn't not fit the width of the Word page.

That's why I'm seeking a way to do the following things :
1) calculate the number of columns of the xls table
2) find the width of each column (by dividing the width of one Word
page by the number of columns)
3) give to each column this specific width.

The column A always has the same width since it contains the wordings
of the lines.

Any help is welcome. Thank you very much by advance.

Bye

  #2   Report Post  
 
Posts: n/a
Default

Anyone to help me ? Please, please, please....

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Paste from Word table so that 1 table cell = 1 Excel cell Dave G Excel Discussion (Misc queries) 4 June 17th 05 12:16 AM
insert field from Word into Excel Kaththea Excel Worksheet Functions 6 June 8th 05 06:56 PM
Pasting a Word Table into Excel Dee Excel Discussion (Misc queries) 1 April 6th 05 01:38 AM
How to embed Word document into Excel and retain sizing, formatti. Kent Excel Discussion (Misc queries) 0 February 2nd 05 07:37 PM
Pivot Table Security in Excel JBankson Excel Discussion (Misc queries) 0 February 2nd 05 12:01 AM


All times are GMT +1. The time now is 08:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"