vba open workbooks

[chungtinhlak]

Is there a way to open a workbook in vba if the path length is greater than 255 characters?

[mdmackillop]

Try changing directory to split the path length

Sub LongPath()
ChDir "C:\AAA"
ChDir CurDir & "\BBB"
Workbooks.Open "Test.xls"
End Sub