Excel Workbook Window Handle

[Hexonx]

Does anyone know how to obtain the window handle of a Workbook window? By enumerating child windows of the Excel application window, I've determined the windows classname to be "EXCEL7", but calling FindWindow and FindWindowEx (with various parm configurations) yields nothing. Any ideas?

What I want to do is to set the workbook window into a Visual Basic window. I've seen it done by using the Excel Application main window, but this requires an instance of Excel for each window I want to show. Because of this, I'd like to use the workbook windows instead so that I have a single instance of Excel application.

 

[bodhi]

Am clueless about this but a quick SOTW came up with

http://www.excel-center.com/mailing/158701h.htm

which,at a glance, looks as though it might have some relevant code samples.

 

[Hexonx]

Thanks bodhi, that was helpful. I had code working by enumerating all child windows of the XLMAIN window class until I found window class EXCEL7. The code you pointed to is more efficient, since I don't have to enumerate windows at all.

Thanks again.