disable all links if workbook1.xls is not open

[oo0tommyk0oo]

Hi, I have a quick question on update links.

I have a workbook which reads off another master SS (which opens with it). Sometimes this workbook is used offsite, where the master is not available, a On Error command is used to account for this. However the update links error still appears. I was wondering if there is a way to disable all links.. so if master SS not found disable all links...

It is not essential as it only takes two click to get rid of the links error, but some of the people i work with have minor heart attacks when they see any Error message in excel, and it takes them 30min to build up the confidence to come and tell me..... very unproductive!

Thanks for any help

Code bellow

Please Login or Register  to view this content.

[davegugg]

How about this instead:

Please Login or Register  to view this content.

No need for nasty error catcher.

[oo0tommyk0oo]

Thanks for the reply,

I tired your code and it still comes up with cannot find S:xxxxxxxxxxxxxxxxx\ MTS-Master.xlsx

and then the update links error.

[davegugg]

Are you trying to find out if the MTS-Master file is in that location? If so, use the dir function.

[oo0tommyk0oo]

No, sorry should have explained it better. Basically if the workbook is opened in the office, the master SS will always be found at that location and should open. However this workbook is often emailed and in that case the master will not be found and should not give an error, as it does not matter that the Master SS is not open off site. I have managed to stop it saying cannot find ..... master.xls but i cannot get it to stop trying to update links.

Thanks for any help

[davegugg]

Ok, I'm still not sure if I understand, but do you know what the arguments for the Workbook.Open function are? You have UpdateLinks:=1, which tells Excel to try to update the links. If you don't want it to update the links, do UpdateLinks:=0 in your original code.

[oo0tommyk0oo]

Ok, so i think i will need a IF command.

So If Master SS is found and opened UpdateLinks:=1

If not UpdateLinks:=0

I will give it a try

Thanks for the help

[oo0tommyk0oo]

Please Login or Register  to view this content.

This was the best i could do but am getting an error now on ThisWorkbook.Activate , UpdateLinks:=0

[snb]

Change the properties of the workbook so it won't be updated automatically

Please Login or Register  to view this content.

When opening the workbook you can decide to update or not with:

Please Login or Register  to view this content.

[oo0tommyk0oo]

Thank you so much, works great!