MarkAndrews
Well-known Member
- Joined
- May 2, 2006
- Messages
- 1,970
- Office Version
- 2010
- Platform
- Windows
I have a problem with the following code
I changed (On both Occurances)
ChDir "'\\hqnas01p\cac$\Management\Customer Relations\Complaint Log"
from
ChDir "'Z:\Management\Customer Relations\Complaint Log"
So I could dial straight into the server, over using a filepath & this wont work now, I could change it back - but it has all sorts of complications with certain people not having certain drives mapped to their profile
Any idea's Guys?
TIA
I changed (On both Occurances)
ChDir "'\\hqnas01p\cac$\Management\Customer Relations\Complaint Log"
from
ChDir "'Z:\Management\Customer Relations\Complaint Log"
So I could dial straight into the server, over using a filepath & this wont work now, I could change it back - but it has all sorts of complications with certain people not having certain drives mapped to their profile
Any idea's Guys?
TIA
Code:
Sub Open_Complaint_Log()
'Script which opens the complaint log from its network location
'Link changed to CAC S: MA
Application.ScreenUpdating = False
ChDir "'\\hqnas01p\cac$\Management\Customer Relations\Complaint Log"
Workbooks.Open Filename:= _
"'\\hqnas01p\cac$\Management\Customer Relations\Complaint Log\Complaint Log 2006.xls"
Application.ScreenUpdating = True
End Sub