ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Showing NULL Command Bar handle (https://www.excelbanter.com/excel-discussion-misc-queries/145021-showing-null-command-bar-handle.html)

[email protected]

Showing NULL Command Bar handle
 
Hi,

I want to fetch Excel Command Bar and Status bar handles. To get
handles, i have written following code:

Please assume that excel application is already opened on desktop
whose caption is "EXCEL_TEST".

------------------------------------------------------------------------------------------------------------------------------------------------
Line1: HWND hWndMainXLS = FindWindow("XLMAIN",
"EXCEL_TEST");
Line2: HWND hWndStatusBar = FindWindowEx(hWndXLDesk, 0,
"EXCEL4", NULL);
Line3: HWND hWndCommandBar = FindWindowEx(hWndXL, 0,
"MsoCommandBar", NULL);
------------------------------------------------------------------------------------------------------------------------------------------------

In above code, Line 1 and Line 2 successfully returns handler of main
excel sheet and status bar, but code in Line3 returns NULL handler. In
nutshell, above code doesn't return me the correct handler for
CommandBar.

Please let us know what is the problem in the code.

Thank You,
Jaydeep



All times are GMT +1. The time now is 08:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com