John Croson's Blog Home

This Word document was developed to manage our claims follow-up process, and control the way our staff filled out these claim letters. When this document opens, it displays a form for the user to fill in, and: Reads in a text file used to populate a Combo Box for the user to select a company name (our clients). This file is on a network share. See commented code for details. Checks active directory for the users information and automatically populates the salutation area of the form with the proper information using bookmarks as placeholders for the variable data. Performs rudimentary form input checking for the existence of data, and has some constraints, i.e. only numbers and dashes allowed in the zip code field, and only numbers and "/" allowed in the date field. This data is also sent to the document, using bookmarks for placement of the variable data. When the user clicks OK, the Print dialog automatically pops up, and upon completion of printing, the form closes withou...

This report is run regularly to check for duplicate patient DOS visits. If you have Tiger, you can use the parameters at the bottom of the sample report to see how ours is built. As usual, the PHI (Patient Health Information) has been changed, but not the format. Download the spreadsheet and sample file to view the results. The VBA is commented fairly well, so it should be pretty easy to follow and modify to your needs. Read this doc on Scribd: Duplicate Report Parser This Excel Spreadsheet will parse the Duplicate Patient Report data from Tiger companies: #3 - #12 - #14 DO NOT EXPECT THIS TO WORK ON ANY OTHERS.. Although you could try it, it might just work… ;) 1. Run duplicate report and View it in Tiger. 2. Save it to a location like your desktop. 3. Click the "Open File" button and select your saved report! 4. Watch and say "Oooooooohhhh!" Open File This is sample data. Read this doc on Scribd: Sample for Duplicate Re...

This Excel spreadsheet takes text from Refund List reports in Misys PM (AIX Version) and generates a nicely formatted check register. You can't see it, because it's hidden behind the "form". After the import of the data, it is revealed. This simply doesn't do one sheet, and "that's all you get". It will allow you to save your results, and come back to a report later and import it, adding to the bottom of this spreadsheet. It "knows" what cell was last used, and jumps to the next available row. One of my co-workers needed this to track Refunds and compare our numbers to the actual bank account balances....this helped keep him sane. I'd show you the source text, except it's full of PHI (Protected Health Information), protected by HIPPA. Well, I've modified a sample of the text that gets pulled in to this spreadsheet so PHI is not revealed. Suffice to say, it's messy, no common delimiters, and unusable unless you intend on...

I had a client when I worked for techWorks that is an industrial bakery. Mmmmm, the smell of butter spindles still makes my mouth water....wait, I digress. Again. They had purchased a disposal system that would weigh and dump their bad batches of goods, or poor mixes, etc. While it conformed to EPA standards, they also needed and wanted a method of determining what production line the waste came from, when it was dumped, what shift generated it, etc. I found a good example of PLC data extraction through DDE and Excel riding on RSLinxs' back for communication, so hacked up what Chris Elston originally wrote. This version keeps backups of itself on a daily basis, grabs PLC data upon each dump and updates the spreadsheet automagically. Here is my hacked up version of a very good example provided by Chris Elston. Feel free to download it and view the VBA. Read this doc on Scribd: ENDRES LOG ACTIVE TYPE READ DATA ROOM LINE RESULT OF WEIGHT DATE/TIME