changing file path

[Patricia0923]

Hi,
I need to extract data from files that are currently located down this path

c:\Users\Owner\Desktop\R2D2\Data\NS25465\labor.xls

How do I write code to find and open "labor.xls"?

Can I use ChDir Left(ThisWorkbook.Path, InStr(1, ThisWorkbook.Path, ":"))
ChDir ThisWorkbook.Path
ChDir "..\..\data"

Thank you!

 

[XLfriend777]

Hi Patricia - Have you tried something simple like the code below?

Sub Patricia0923_OpenFile()
        Workbooks.Open ("c:\Excel\opentest\test3.xlsx")
End Sub

 

[Patricia0923]

Hi Patricia - Have you tried something simple like the code below?

Sub Patricia0923_OpenFile()
        Workbooks.Open ("c:\Excel\opentest\test3.xlsx")
End Sub

Thanks.
I am wanting to understand the ..\..\ idea

this spreadsheet has to be used in over 14000 locations