Hi,

We need to save and close the vendors worksheet before we open the.
As far as creating a "New Vendor" file I did not see in your post that you needed this.
I believe you need to create a template so if required you can create the new vendor.