Pull down and Save to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a form in Word that would have many pull down menus
and then save the information in either an Excel spreadsheet of access DB. I
am not sure how to start and would appreciate any help on where to begin.

Thanks in advance.
 
Hi =?Utf-8?B?RGFuaWVsbA==?=,
I would like to create a form in Word that would have many pull down menus
and then save the information in either an Excel spreadsheet of access DB. I
am not sure how to start and would appreciate any help on where to begin.
I'm curious why you'd create the form (userform / dialog box?) in Word, then
want to save the information in a different application?

One things certain: this would require a macro (VBA) solution, which means you
need to follow up on this in a word.vba newsgroup (for developer questions).
When you ask there, you should include more information, such as

- the reason (because everyone will ask the same question I did)

- the version of Word

- any macro/programming background you may have, so that we know at what level
to start the discussion

- more details about what you want to do and how it should look

To give yourself some background, I recommend looking at the tutorials on
word.mvps.org concerning creating UserForms, creating menus/toolbars and
exchanging data with Excel/Access.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)
 
I am not sure which application the end user will be using. I was hoping to
get something put together in Word as a starter then do the back end when
they make up their mind.
 
Back
Top