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.
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.