Windows("vendor" & x).Activate

error message!! is giving me "subscript out of range"

"Mike H." wrote:

This command will allow you to turn the path into a variable. Have you
initial file open and then add this line instead of the one below:

Use this:
let FilePath=ThisWorkbook.Path

Instead of this one:
let Filepath="c:\temp\" 'you need to put your path here!