wordsite.com

   
 


Examples

Generate research reports in seconds

Compose complexdocs quickly and easily

Enroll more customers faster

Double the impact of every document

Write better specifications

Translate documents as you type

Attach audit trail to Word documents

Slash the cost of training documents

Convert printed matter to HTML database format

Get direct access to data from Word

Slash the cost of SEC documents

Get prompted for missing data

Create complete documents without typing

Microsoft is a registered trademark of Microsoft Corporation
 
 

   


On-line bookseller converts printed catalog to
HTML database format automatically,
with the help of a Microsoft
® Word macro

"Great work! I am delighted. I'm especially impressed with the extensive documentation you provided in the form of comments for the subroutines. Thanks so much for your speedy and accurate work. Our old macro never produced results of this quality, even when it would run."
Rick Harmon
Bud Plant Comic Art

A custom software solution for Microsoft® Word has drastically cut the cost of producing an on-line catalog for Bud Plant Comic Art, Grass Valley, California.

The company's printed catalog is produced using Quark® XPress desktop publishing software. Converting the catalog files into usable HTML files was a time-consuming, error-prone task.


The catalog copy starts out as a desktop publishing file suitable for printout. 

 


The macro applies HTML tags and divides the tagged text into separate database fields.

The conversion was made more difficult by the fact that the company's internet service provider required the HTML code to be stored in a database with separate fields for book descriptions, prices, graphics, and other data. Descriptions that exceed 255 characters had to be broken into multiple fields of less than 255 characters each.

A further complicating factor involved a tendency to lose paragraph style and formatting information when exporting the catalog copy. To counter this problem, the company decided to export its catalog files to Microsoft Word, where the data could be manipulated by a macro program.

I developed a macro to apply HTML tags to the catalog copy and to divide the tagged text into separate database fields. The macro automatically detects when a book description exceeds the capacity of the database and transfers such descriptions to a separate error file so that processing can continue without interruption.

Extend the power of Microsoft Word . . .

For more information about menus, macros, toolbars, templates, add-ins, and other ways to produce better documents in less time, call me at 920/779-9148 or contact me by email at billcoan@wordsite.com.