merlin63 wrote ...

How do I tell the spreadsheet not go to a specific directory and just
look for the files it needs in the same directory that the original
spreadsheet resides?

Use:

ThisWorkbook.Path

Jamie.

--