Hi

I have an embedded word document in my excel file and I want to be able to create a table with a specified number of rows and coloums and also fill it in with data from my excel sheet.

But first I want to start by creating the table in a specified place in the word document. So far to copy text from excel to word I have been using the text form field with a command like the one below;

Please Login or Register  to view this content.
Can a table be inserted in this way or is there a way of pointing to a specific part of the document.

So the table will be between two a ten rows depending on the data in the excel

My code already works out the number of rows it needs and stores it as an integer (iRow)

I was wonedering if it is better to create one row at a time and fill in the data or create the whole table and fill in the cells after.

I would much prefer information rather than just code that works as I have many different types of tables I need to produce in the future so I really need to understand what the code is doing.

Thanks

D_e

PS. If anyone knows a really good book that explains moving data between excel and word and working with embedded object files please let me know.