Linking 2 workbooks

[michellecairns]

Hi,

I need a macro that will trigger the opening of a 2nd workbook automatically, when a first workbook is opened by the end user. Any help gratefully recieved. I have had one previously but it wasn't opening the 2nd workbook fully so I've ended up scrapping it.

[arlu1201]

Do you want the user to select the path to the 2nd workbook or do u want to open it automatically?

[michellecairns]

Hi Arlu, the less user envolvement the better. I'm really looking for something automatic?

[Kyle123]

in the ThisWorkbook module:

Please Login or Register  to view this content.

[michellecairns]

Hi Kyle,

I've changed this code to read:

Please Login or Register  to view this content.

But it doesn't seem to work. Am I missing something. I do it via Microsoft Visual Basics making sure I change the drop down box to read "this workbook" and save / run but nothing seems to actually save? Any help appreciated.

[Kyle123]

hi michelle, this runs when the workbook is opened. So you'll need to save the workbook with the code in and then re-open it

[michellecairns]

MyLists.xlsKier Timesheets.xlsHi Kyle,

Yep, I've tried that a few times but to no avail. I've attached the workbooks in the hope that, that will help.

[Kyle123]

Hi Michelle, you've put the code in a module.

It needs to go in the "ThisWorkbook" module, it's the one at the bottom of the other sheets

[michellecairns]

Sorry Kyle, I am a macro idiot and I have no idea what you mean by that. Laymans terms?

[Kyle123]

See below:

CopytoThisWorkbook.gif

[michellecairns]

Thank you Kyle, you have made my Christmas! 3 weeks I've being trying to get a macro that works and allows the drop down boxes in the first workbook to continue working properly, I believe that this is macro number 11! I hope you're off to polish that armour.