Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Excel tables into Word
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Excel tables into Word
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" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Excel tables into Word
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 "Smitch" wrote in message ... 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" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Word copying info from Excel to Word without gridlines / bor | Excel Discussion (Misc queries) | |||
Copying word tables of different column width to excel. | Excel Discussion (Misc queries) | |||
copying word tables into excel | Excel Worksheet Functions | |||
copying word tables into excel | Excel Worksheet Functions | |||
VBA from Excel 97-Word 97 tables | Excel Programming |