Home > Posts > Multiple Word documents template-based generator from Excel spreadsheet data (via VBScript/WSH)

Multiple Word documents template-based generator from Excel spreadsheet data (via VBScript/WSH)

The tranXform free transformations software collection has been enhanced with a document generator, called DocGen. Copying its simple usage instructions here:

It’s a script in VBScript used to generate multiple Microsoft Word documents based on templates (.DOC) and Excel spreadsheet (.XLS) data to fill-in

Instructions:

  1. Add/Edit document templates (.DOC) in Templates folder (put-in tags of any form, e.g. #SURNAME#)
  2. Add/Edit XLS data in Data folder – each XLS has two columns (a tuple) per row, of the form (TAG, VALUE)
  3. At the Data folder, drag-drop an XLS file onto MakeDocuments.vbs
  4. One document is generated for each template at the Output folder, filling-in the data (replacing the tags with respective values) from the spreadsheet file

Requirements: you must have WSH (Windows Scripting Host) installed. If you don’t have it, you can download WSH from Microsoft

(C)opyright 2009 – Zoomicon / George Birbilis
Free to use / give due credit

 

Advertisements
Categories: Posts Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: