Adapting VBA from Word to work in Excel

My bad. I didn't read the code carefully enough. The code I provided is suitable for ThisWorkbook.Path. But you are using a local variable called Path that has the delimiter appended. (That is why I never use a variable name that is the same as a built-in object method.)

Anyway, for your code, the correct line of code is, as you say:

   Workbooks.Open Filename:=Path & DirN

I am guessing you have already tried it by now and found it works.

Thank you for your assistance. Workbooks.Open Filename:=Path & DirN should work but it is not. I am so perplexed by this. As I said im a total novice though i felt i was getting somewhere and this has stumped me all weekend.This part of the code works in Word, must be complicated to adapt to Excel.
Is there a better way to achieve what Im after, Folder Browser> Run Macro on all .xls files in Selected Folder and SubFolders? Im must be wrong somewhere. So stumped. Again thank you for your input.