Hi,
I was able to correct the error.

Now when it runs, it creates a new spreadsheet for the vendor but does not populate on the sheets. Basically creating blank files.