Adapting VBA from Word to work in Excel

Thank you for your input. I receive the same error still. If I change it to Workbooks.Open Filename:="\" & Path & DirN the error states "\C:\ExcelTest\Testworkbook1.xls" cannot be found (cause of the \ in front of the drive), so why wouldnt Workbooks.Open Filename:=Path & DirN work? Seems like it should.