Microsoft is a registered trademark of Microsoft Corporation
"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."
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 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 firstname.lastname@example.org.