Thread: Vba
View Single Post
 
Old 09-23-2011, 01:42 AM
HorizonSC HorizonSC is offline Windows Vista Office 2003
Novice
 
Join Date: Sep 2011
Posts: 5
HorizonSC is on a distinguished road
Default Vba

Hello all, does anyone know if there is a way to get word to fetch a range of data from excel, and then paste it into a word TABLE? (Not a embedded spreadsheet section.) I've got a document which is essentially a custom-created array in excel (see this thread for details) which is generated by the user interacting with a tick list generating a 5 column, n-row output array.

I'd like to link excel with a word document to then automatically paste it into a table, adding or removing rows as necessary.Furthermore, I'd like the coumn titles to appear on every page - is there a way to do this?
Reply With Quote