need to get info from an ASK field into an EXCEL spreadsheet

[briggsy616]

i am using Word XP 2003 and i have recorded a macro to gather certain
information using an ASK field. i have used six ASK fields one for
username, client name, address, phone no, producted order, and cost of
product. the problem is i have to send the entred username, client name and
the date to a spreadsheet in Excel - which i do not know how to do! Can
someone help me please!

 

[Jean-Guy Marcil]

briggsy616 was telling us:
briggsy616 nous racontait que :

i am using Word XP 2003 and i have recorded a macro to gather certain
information using an ASK field. i have used six ASK fields one for
username, client name, address, phone no, producted order, and cost of
product. the problem is i have to send the entred username, client
name and the date to a spreadsheet in Excel - which i do not know how
to do! Can someone help me please!

You should use a userform if you have 6 items.

See here to get you started:
http://word.mvps.org/faqs/Userforms/index.htm

Then, to transfer the information to Excel:
http://word.mvps.org/faqs/interdev/controlxlfromword.htm

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[briggsy616]

Thank you that was very helpful