Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have 3 workbooks. Call them A,B and C.

B receives data from C via a link

A receives data from B, including data B received from C

I want to update all the links when I open A

I get that a Workbook_open event is used from ThisWorkbook in Workbook A, in VBA

I have spent many hours attempting to get this to work to no avail

Tiny bits of my code work but have troubles with updating links, which stalls the code that starts on A opening

share|improve this question
    
This is a cop out, but I assume you can't just merge the workbooks? –  soandos Jun 1 '11 at 1:48
    
Unfortunately no. Each workbook is for a seperate financial year and I need to keep them seperate. Cheers –  ozadam Jun 1 '11 at 1:54

1 Answer 1

So the way you are doing this is bad, in the sense that you have two layers of inheritance, leading to needless complication. If you use the instructions here to simply pull data from both workbooks your troubles will be solved.

This bypasses completely how to do what amounts to two layers of inheritance, events, and the like. I think that is a good thing. If you want to have someone figure out how to do that specifically, I think that is a topic for another question.

share|improve this answer
    
Thanks for the info. Turns out I was trying too hard. The links update without any help from me. All I want to do is disable this message. –  ozadam Jun 2 '11 at 12:07
    
Sorry, wrong button. Disable this message. This workbook contains one or more links that cannot be updated. You get continue or edit links options. I just want to disable this box or prevent it from appearing. Thanks –  ozadam Jun 2 '11 at 12:18
    
Ask it as a new question, but you might want to try "On Error Resume Next" WARNING it does not fix the error, just pretends that it did not happen. –  soandos Jun 2 '11 at 13:11

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.