Copying Excel tables into Word

[Darren V]

Hello

I'm looking to write some VBA code to copy a large table from Excel into
Word, and format it so it fits nicely with columns the right width etc. Its
possible to copy and paste it manually, but its lots of work and I'll need
to do this regularly.

Is it possible to get Excel to interact with Word in this way?

Anyone have any ideas?

Many thanks

Darren

 

[Guest]

Hi Darren,

This can be complicated or simple... are you trying to do a generic function
that is going to account for how much horizontal space you have to work with?
If it is not enough is the solution to insert section breaks and format the
page to adjust for size of table? And so on…

If you have a fairly limited type of table sizes it might be pretty easy.
The other option is use Word Table styles and apply those to copy-paste
version of the table… you could automate that… via macro recorder… which may
give you the most bang for little buck ;-)

Cheers,

~Smitch

 

[Darren V]

Hey Smitch.

Will give it a try, thanks for responding.

Cheers,

Darren

Supposing I have this table saved in a workbook called "Book1" and a sheet
called "Sheet