Mike,

Maybe you can assist or direct the next issue I am having, the network
location! and people placing the files in a repetative place and naming
convention. The BOM directory will have many sub directories and from within
there will be the vendor forms. The structure is alway the same, but the file
names may differ by vendor or operator.

Can I call a dialog box (file open) and go get the vendor forms (regardless
of the names)? there may only be 1 or upto 6

"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!