API - Window on top of screen

[Joakim N]

Hi,

I am using API (VBA Excel v2106) to activate a workbook. In my example below I try to activate "Book3.xlsx".

Issue:
- Function lhWndWorkbookWindow() returns 0 if the workbook isn't already active.

NOTE!
In reality I am trying to activate correct workbook in Excel from coding in VBA Microsoft Access. I just wanted to simplify my case for this forum. It's the same issue having the code directly in VBA Excel.

Please Login or Register  to view this content.

[Marc L]

Hi !

That no needs API, why don't you use general VBA statements ?

And just respecting model object, a good code does not need to activate anything !
So the question is why do you need to activate a workbook ?

[Joakim N]

Hi,

My issue is that all VBA code is in Microsoft Access (Including API). Then I invoke Excel to do my quite complicated reports. I have tried to use normal VBA code to show correct workbook in Excel. I gave up that by a lot of struggling. Then I involved API to get a more stable process. I hoped.

If you have an example by doing that in VBA coding I'd appreciate that.

[Marc L]

It depends on your code and on all you did not explain ! As we are not mind readers …

But the most important - whatever the process - is a good code very often does not need to activate anything (+99%) !

So at least answer to this question : why do you need to activate a workbook ?