AVaulin
asked on
Embedded Excel sheet controlling
I've embedded Excel sheet into my view (I used standard OLE COleInsertDialog). Now I want to control that sheet. For example I want to open existing xls-file. What do I have to do?
ASKER
Yes, menus were merged. But Excel's "File" menu is not accessable. You can try open excel file in DevStudio and see how menus will be merged: "File" menu will be from Studio and others will be from Excel.
So I can't accept your answer.
So I can't accept your answer.
When you used COleInserDialog did ya use the option of inserting from existing file. Then you browse for the excel sheet you want to embed and that xls will be opened in your view.
ASKER
Yes, it works. But it does not mean controlling (see question text). How (for example) can I change A1 cell text? MS sample COMEXCEL uses "Range" function to do it. But they do not use embedding in that sample.
ASKER
Adjusted points to 300
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.
Let me try. Wait some time...
Let me try. Wait some time...
ASKER
It works exactly how I wanted.
Thank you.
Thank you.
If the two menus did not merge, then houston we have problem :)
Good Luck!