Paperclipper
Board Regular
- Joined
- Mar 11, 2004
- Messages
- 110
this sounds simple, but i havent got a clue!
the path will change for different machines i load the workbk on... so how do i code to open up the source workbks in either the current dir or a subfolder within it?
Sub OpenUp()
ChDir _
"S:\Contracts\Contract Data Sources"
Workbooks.Open Filename:= _
"S:\Contracts\Contract Data Sources\Contracts Breakdown 1980.xls" _
, UpdateLinks:=0
End Sub
This has got me baffled!
the path will change for different machines i load the workbk on... so how do i code to open up the source workbks in either the current dir or a subfolder within it?
Sub OpenUp()
ChDir _
"S:\Contracts\Contract Data Sources"
Workbooks.Open Filename:= _
"S:\Contracts\Contract Data Sources\Contracts Breakdown 1980.xls" _
, UpdateLinks:=0
End Sub
This has got me baffled!