During VBA switching focus

[malcmail]

I have two parts of a macro that I'm trying to get to play nice together. As separate pieces they work but there is a vital link I cannot figure out.

The full code looks a bit like this..

Please Login or Register  to view this content.

So the idea is it opens a file (eventually it will loop), unlocks the VBA. That all works fine. The last bit of code should delete a module from it then re-import it. The problem is that the code seems to operate on My Addins.xlam where it is stored, and I cannot for the life of me work out how to change the focus to the newly opened file. ANy ideas most welcome.

[Norie]

Have you tried changing this code so it refers to the workbook you've opened?

Please Login or Register  to view this content.

[malcmail]

Have you tried changing this code so it refers to the workbook you've opened?

Please Login or Register  to view this content.

Yup. Tried activating and selecting the named workbbok but neither made any difference at all.

[Norie]

On those lines of code why are you using Application instead of xlAp which is the instance of Excel you've opened the workbook in?

By the way, I wasn't suggesting activating or selecting the workbook, what I was trying to suggest was explicitly referencing the workbook, perhaps using the reference oWb.

[malcmail]

I've kind of last track of what I've tried by now tbh. I did try activate / select. Also tried specific referencing but the code won't run. However, I've just tried oWb instead of xlAp and it seems to have worked! You're a lifesaver! Thanks as always.