Prev: for each oPara in Paragraphs touches each paragraph twice
Next: code to "remove" dictionaries for Word 2010
From: dlc444 on 21 Apr 2010 15:38 Hello all. I am trying to automate at least a portion of my work. I write commercial appraisals that are generally between 100 to 150 pages where there is a lot of repeated information, such as the name of a property, address, client, etc. I have been looking for a method whereby I could create a spreadsheet (or database) that would automatically import certain fields throughout a document while maintaining the formatting of the main document. If the information in the spreadsheet changes, it is bumped over to the word document (and vice versa if possible). Entire sections could be written in a spreadsheet which could be shared between coworkers and updated on the fly as new information is acquired. Does anyone have any suggestions on how to do this? I have done some programming, but nothing like this.
From: Doug Robbins - Word MVP on 21 Apr 2010 19:00
A couple of years ago, on a commercial basis, I created such an application for a guy name Matt Griffith email address: mgriffith[atsymbol]tropicalappraisal[dot]com You might contact him and see if he is prepared to share it with you on some basis. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "dlc444" <dlc444(a)discussions.microsoft.com> wrote in message news:80BFF637-BB15-4A04-B943-A48735EFF2A2(a)microsoft.com... > Hello all. > > I am trying to automate at least a portion of my work. > > I write commercial appraisals that are generally between 100 to 150 pages > where there is a lot of repeated information, such as the name of a > property, address, client, etc. > > I have been looking for a method whereby I could create a spreadsheet (or > database) that would automatically import certain fields throughout a > document while maintaining the formatting of the main document. If the > information in the spreadsheet changes, it is bumped over to the word > document (and vice versa if possible). > > Entire sections could be written in a spreadsheet which could be shared > between coworkers and updated on the fly as new information is acquired. > > Does anyone have any suggestions on how to do this? I have done some > programming, but nothing like this. |