Macropod, that macro does to a pretty decent job at outputting the txt into an xls file. There are a couple fields that are still off (mainly the first item under each heading), but I don't think any of them are going to affect me.

My ultimate goal is to run a script that will pull all of the updated prices for each item and copy it to Cost/Inventory Sheet. Is this something that you could help me write as well? I am thinking it would go something like this:

1. Search through the outputted text for the item "code". Ex. Jim Beam would be "4079".
2. Once the item is found in the outputted text, see if there is any changes in the "Price" field based on the price in the Cost/Inventory Sheet.
3. If that price is changed, update the price in the Cost/Inventory Sheet and highlight it to show there was a change.
4. Repeat this process for each item in the inventory

Thanks again for all the help and I hope you have a good holiday!