Word Complex Table - Copy into code for

[Chrisjd2]

Hi,

Is there a way, to copy an existing table into my code, so I can re-write it back from the code.

Basically, I have a spreadsheet that opens an existing Word document with said Table in, then I add text so certain cell locations in the table.

I would like the excel to open a blank word document, and write the exact table to the document, and then I put my data in..

This just saves having to have a word doc be with the spreadsheet all the time, instead the excel will generate this.

Does that make sense lol?

Chris

 

[Norie]

Chris

I'm not quite following the sequence here, where are you copying from/to, where/when are you adding data?

Also, would it just be data you would be dealing with or would it also include formatting?

 

[Chrisjd2]

Norie,

At the moment I have a 'Blank Template.doc' which is just a table, with nested tables inside text etc.. (Basically it is an entry form)

Now, this document is opened from excel where I pass variables into the word doc to autocomplete the entry form.

Ideally, I don't want to be opening the 'Blank Template.doc' each time. It would be better to create a Word document from my excel code, and then for the code to write the table to the word file. Then I can pass my variables in to complete the entry form..

..............

Without trying create the code to generate the table, is it possible to convert the existing table in a code form? So I can then use it when I create the new table?

I'm not sure how well I've explained that?

Sorry if you don't understand lol

 

[Norie]

I don't think that's going to be possible, for a start I don't think a Word table can exist outside a Word document.

Why are you against opening 'Blank Template.doc'?

 

[Macropod]

It's easy enough to create tables in Word via a macro, but you might find it easier to accomplish what you want if you create one in Excel, using formulae to populate it with the relevant data, then simply copy & paste that into a Word document. For the latter part, see, for example: https://www.mrexcel.com/forum/gener...et-word-document-post4941026.html#post4941026