Extracting data from word using VB

[tp2468]

Hi there,

I have created a survey form in a word documents using textboxs and checkboxs. I have created a macro to read the values but I do not know how to carry the variables across to excel so I can read write the results to the spreadsheet. How can I do this?

Thanks in advance

Tom

 

[doofusboy]

One way to do it would be to have your same Word macro create an Excel workbook and insert the data or insert the data to an existing workbook.

 

[tp2468]

I already have an excel sheet setup, what I need to do is to be able to open this. I done this before, transfering between different excel books using Windows("Book2").Activate but this code will not work when ran from the word document.