Thisworkbook.activate - semi working

[James_Latimer]

EDIT! - I've found that once i click on the Excel instance with MainWkb open then the code below works fine - it seems i have to manually activate MainWkb the first time!?!?!?!?!?! Any ideas how to get around this?


Excel 2016 / Win 10

Hello fellow Excel'ers,

I am having some trouble switching between workbooks with VBA. I am simply trying to activate a workbook but it only semi-works...

I have a variable MainWkb that has been set as my workbook. I then have another instance QCWkb that i set to Workbooks.Open(file that i want to open).

I've tried the following:

MainWKb.Activate

and

MainWkb.Sheets(sheetnamehere).Activate

Although the workbook (MainWkb) is indeed activating, it is not being brought to the front. This means that i then have to minimise the opened workbook (QCWkb) before i can see my workbook (MainWkb).

I hope that this makes sense and that i'm not missing something blatantly obvious!

If anyone can shine some light on how to make another workbook activate and come to the front of the screen it would be much appreciated.

Thanks in advance.

 

[James_Latimer]

OK... so i have it working, but i'm still unsure as to why it wasn't working before...

My code was opening another workbook (QCWkb), it then called another routine that adds a new sheet to MainWkb, i then called a message box (informs user of keypress to use etc) and then activated QCWkb. I found that when i don't call the message box then everything works just fine!?

Given that i try to follow the path of least resistance through life, i decided to 'sack off' the message box and i'll add the information to the worksheet instead.