Re: Send Word Data to Excel

Thanks for the help Graham. Whenever I try to run the macro in my own Word
file, I keep getting an error on this line:
Dim vConnection As New ADODB.Connection
I added in the reference to ADO Ext. 2.8 for DDL and Security, so I'm not
sure what the problem is now.

Once I got it working, sort of, through the Word file that can be downloaded
from the site, but when I ran it, by clicking on the Toolbar that says
‘Extract to Database’ a window opens, and I can see that I am in the ‘Batch’
folder (which I set up for this task), but I can’t see the database or any
word docs or anything at all. Then I get a message box that says ‘no folder
was selected’. Can you think of what I may be doing wrong? I thought I
followed the instructions on the site pretty closely.


Thanks,
Ryan---



--
RyGuy


"Graham Mayor" wrote:

See http://gregmaxey.mvps.org/Extract_Form_Data.htm
or for a one-off
Set tools > options > Save > Save data only for forms to produce a comma
delimited text file that can be opened in Excel.
To activate all the controls in Word you need to unprotect the document. If
that is password protected you will need the password in order to process
the document in the manner you envisage - or create a new version of the
form without the protection (or with your own password) See
http://www.gmayor.com/Remove_Password.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


ryguy7272 wrote:
The document seems to have Form Fields, similar to the examples here:
http://uwec.edu/help/Word03/frm-flds.htm

I can't do much with this document. Most of the controls are
disabled. I can't even copy/paste. Everything appears to be
'locked'. How can I unlock this kind of template? How can I
transfer the data from these Form Fields into an Excel spread***?

Regards,
Ryan---




Someone sent me a document today, where I can double-click on a
section, like a name, address, a telephone number, etc., and the
entire section becomes active available for inputting text. So you
can double-click, add your names, a few other strings of text, and
even click on little boxes which show check 'x' marks when clicked.
I am wondering what kind of formatting this is. Also, I am
wondering if there is a way to use VBA to take all of these inputs
from a user, and click a button to export each 'range' to Excel.
I've done programming in Excel, and used DocVariables in Word, to
send information from excel to Word. It worked quite well in fact.
I have never taken variables from Word, and exported then to Excel
though. I'm pretty sure if you can go one way, you can go the other
way too.

I've read the info. here:
http://www.word.mvps.org/FAQs/InterDev/ControlXLFromWord.htm

This site is great, but I don't think this is going to give me the
answer that I am after. Is there another resource oin the web that
describes how to get data from Word to Excel?

Finally, the document seems to be protected. Most of the controls
are disabled in the Word document. Where can I go to enables all
the standard Word features?

Regards,
Ryan---





--
RyGuy



.

Loading