Code Problem

[MarkAndrews]

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

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

 

[MarkAndrews]

This is really confusing me, It worked fine until yesterday & nothing in the document has changed ??

 

[MarkAndrews]

I honestly have no idea with this guys?

Can anyone please advise?

Thanks

 

[Norie]

Mark

When are you trying to access Tools>References...?

 

[MarkAndrews]

Mark

When are you trying to access Tools>References...?

While i am in VBE Norie?

 

[Norie]

But are you trying to access it while in Debug mode?

 

[MarkAndrews]

But are you trying to access it while in Debug mode?

Nope ??