Macro to export word table data to excel

[Simon.xlsx]

Hi All,

I have found a lovely bit of code to export my word table data to an excel spreadsheet. I've modified a bit to suit the job.

This is to pull all the info off a particular form and place it in my excel spreadsheet, what i need it to do is auto look for the next free row in excel and place the data there, currently I have it written in the code to place the info in row 3 of my excel table, clearly this will be a problem when i run the VB on the next form as it will overwrite my previous data.

The Word table data selections will not change, and neither will the excel table columns, I just need each form put into the next row of the excel table

Any help greatly appreciated

Here is the code I am workin with

Please Login or Register  to view this content.

[Tinbendr]

Since you hard code the Word table row/column, there's no need to iterate the row/columns.

I think what you want is:

Please Login or Register  to view this content.

[Simon.xlsx]

Hi David,

Sorry about the slow response, this works perfect for me. thanks very much

You seem to know your stuff so i might ask another question

In my table in word i have some tick boxes, a yes and no box to be precise, would there be a way to link that to the excel table to return a yes or no?

That would be very handy but i can work around it if need be,

Again thanks for your last reply

Simon

[Tinbendr]

Probably. Can you provide a sample sheet and doc?

Sent from my XT557 using Tapatalk 2

[Simon.xlsx]

I have attached my two documents i am working with, I am still in the early design process but you can see what i am going for, currently the vb you supplied covers up to column H on the excel sheet. I can happily change the form if you see an easier way to work it.

Really appreciate your help.

Simon

[Tinbendr]

Content controls, ugh!

Ok, first, it's best if you give a title to all the controls. This only has to be accomplished once.

Please Login or Register  to view this content.

Then, use this.

Please Login or Register  to view this content.

This will export all the content controls to the spreadsheet.

(Why did we rename all the controls if you're not going to refer to them by name? This is just in case you want to include/exclude a control, then you can refer to it by name, and not it's number. It's easier on the humans this way. )

[Simon.xlsx]

I have already done much more than I had intended in the beginning, can't thank you enough for your help, I am a novice at VB but learning fast thanks to the forums

Simon