 | Portfolio |
Title | Description | ||||
 | Macro to Add Name, Phone #, etc., to Form Fields | Word macro to read names, phone numbers, etc., from an E-mail program and then pre-fill this information in form field dropdowns on various distributed templates located on server drives. | |||
 | File Copy Utility | Macro that allows user to copy multiple files from source paths to corresponding destination paths. Paths are entered on Excel worksheet so multiple file copy operations may be performed again and again with ease. Macro checks paths before copying files. Macro can optionally be set to copy files once or to retry copying a file when it is in use until it is not in use. | |||
 | Parse Data Excel Worksheet | Macro to parse information from a text file containing 64 fields of 6,000 lines of data to an Excel worksheet. The macro also formats text from uppercase to sentence and title case, and various fields to the required format such as date, number, etc., in the worksheet. Prior to implementing the macro the data had to be manually entered in the worksheet by hand which took days to complete. The macro completes the data import in minutes. | |||
 |
File Cataloger Macro | Excel macro to catalog files in a folder and to optionally get Microsoft Office file summary information. | |||
 |
Word Document Generator and Router | Macro that generates new documents from a Word template containing form fields for users. The users may error check and route their documents to a central location. The user may view and sort their documents. Images may be added to the routed documents. The routed documents may be viewed, sorted and archived. | |||
 | Form field Spell Check Add-in | Add-in to spell check protected form fields in Word documents and templates. | |||
 | Check List Document Builder | Word macro that merges multiple documents containing different text, and headers, footers and styles from a project file path into a master document. Active-x Check Boxes and Buttons allow user to choose the document from the project file path to be merged. | |||
|
Home About Services Contact Sitemap Publications News and Weather Copyright © 2008 TechAutoma | |||||