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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

briggsy616 - 03 Nov 2006 14:03 GMT

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!

Reply to this Message

Jean-Guy Marcil - 04 Nov 2006 05:56 GMT

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

Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Reply to this Message

briggsy616 - 04 Nov 2006 12:11 GMT

Thank you that was very helpful

Reply to this Message