ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Linking a Word Field into Excel (https://www.excelbanter.com/excel-programming/289594-linking-word-field-into-excel.html)

DesertFox

Linking a Word Field into Excel
 
I use a Form which I have created in Word (Office XP
Edition)to enter data. Several fields of that information
are used in preparation of an Invoice for the work done.
I would like to use Excel to prepare that invoice and
have the needed data entered into select fields in the
Excel spread sheet. Each line of the Excel spread sheet
would come from a different form.

My problem is that when I link the information to the
spreadsheet, it just over writes the data previously
entered in for the earlier form.

Question: How do I force the data from the Word form
enter itself into a new line (next line down) in the
Excel spreadsheet.

I would appreciate any guidance you could offer.
Programming Office is not my area of expertise.

Thanks!

DF


All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com