hiya.....
Ive got a load of workbooks at work, which for whatever reason, keep changing server locations when opening up. Im not sure if its because other people around the plant also use these.
Is it possible I enter some code which always links to the following path on startup :
J:\Materials\2011 MPS\[2011 MPS.xls]
I have an Autpen() command, so just need help in what code to enter into that.
Muchos....
Ive got a load of workbooks at work, which for whatever reason, keep changing server locations when opening up. Im not sure if its because other people around the plant also use these.
Is it possible I enter some code which always links to the following path on startup :
J:\Materials\2011 MPS\[2011 MPS.xls]
I have an Autpen() command, so just need help in what code to enter into that.
Muchos....