Adjust an Excel table with the width of a Word page

  • Thread starter Thread starter jamesTcarville
  • Start date Start date
J

jamesTcarville

Holà 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top