I hope someone can help with this problem.
I am in the process of writing an app which embeds an instances of excel within a form. The user can have multiple copies of this form open so in essence we have multiple instances of excel running in multiple windows.
To embed the excel, the excel app window is made a child of a frame within the form. This is achieved using the SetParent API. All is fine, and the excel can be resized using mouse interaction. However, the problem is that I am unable to actually get focus on the excel sheet to enter or edit data.
Is this a bug or have I forgotton to do something. As a test I set the parent of the excel back to the desktop and I can get focus fine, but when I set the parent to be the frame again, I can't get focus. ANy help would be greatly appreciated.
Thanks in advance
I am in the process of writing an app which embeds an instances of excel within a form. The user can have multiple copies of this form open so in essence we have multiple instances of excel running in multiple windows.
To embed the excel, the excel app window is made a child of a frame within the form. This is achieved using the SetParent API. All is fine, and the excel can be resized using mouse interaction. However, the problem is that I am unable to actually get focus on the excel sheet to enter or edit data.
Is this a bug or have I forgotton to do something. As a test I set the parent of the excel back to the desktop and I can get focus fine, but when I set the parent to be the frame again, I can't get focus. ANy help would be greatly appreciated.
Thanks in advance
