Adapting VBA from Word to work in Excel

Originally Posted by 6StringJazzer

First--I should have said this right away--when asking help for an error, always give the error message that you see. "should work but it is not" What does "not work" mean in this case?

This should work the same in Excel as it does in Word. I would suggest setting a breakpoint on that line of code then when it comes to that line type the following into the Immediate Window:

print Path & DirN

and see if the result is a full pathname that you expect.

Setting a breakpoint: Select the line of code and hit F9
Open the immediate window: Hit CTRL+g

Thank you. The error message I receive is "Run-time error '1004': Method 'Open' of object 'Workbooks' failed".

I have done what you suggested with the break point, upon entering "print Path & DirN" I get the path as C:\ExcelTest\TestFile.Xls.