I know this is easy and I hope I am close. I want to open several files from
different folders. I kow the names of the files so this is what I have.

Workbooks.Open Filename:="Y:\folder\filename.xlsm"

When I run the macro it says file not found. Do I have to use the following
to change folders each time I am using a different folder?

ChDir "Y:\folder"