Hi,

Remember the Vendors workbook and the file should be in the same folder on your drive.
Also i have bit of code that will exit the sub after it look for the first vendor.
it's Called "Exit Sub" remove it to test all vendor's workbook.
If you are leaving data in the TestFile you will need some way of knowing that you already populated the vendor's workbook. And, too, when you open the ven workbook the code will over write sheet 1, but will add to sheet.
Not sure if want it that way.