Macro to export word table data to excel

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.

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

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

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