Using Word to input data into Exce

[Martin Paul]

As usual, apologies if this has been raised before...

Does anyone know.... Is it possible to use a Word document to input data
into Excel spreadsheet? I suppose I'm thinking of a front-end type
approach...

 

[Beth Melton]

Hi Martin,

You can do anything with VBA however there is no direct means using
Word to update an Excel spreadsheet within the applications.

Now you can create a Word form using form fields and the data entered
into the field can be saved as a CSV file type which can be imported
into an Excel spreadsheet. If you want more information post back and
we'll go from there.

Otherwise you may want to post in one of the Word or Excel VBA
newsgroups and someone there may know of a utility or can point you in
the right direction on accomplishing this task.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~
Beth Melton

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/