Link to home
Start Free TrialLog in
Avatar of GivenRandy
GivenRandy

asked on

Display Excel Object on GUI Form

I have an Excel object (Excel.Application, Workbook) that I have filled and print and saved programmatically. Is there an easy way to also plop that on a form?
ASKER CERTIFIED SOLUTION
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of GivenRandy
GivenRandy

ASKER

But, how would I "copy" or attach the dynamic object to that control? I can put the OLE Container on my form with Excel selected and I can even make it visible (using .Visible = True), but I don't want to show the Excel object itself that way (I want it to be on the form).
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image
I'm not sure that  understand what you mean by not wanting to see the Excel object. You see (part of) the spreadsheet unless you Edit or Open the Excel application. If you set the Enabled property top false, you can prevent the user from doing that.
Avatar of GivenRandy
GivenRandy

ASKER

When using a dynamically created object, I don't see it unless I set .Visible = True. I don't want to do that. Also cannot use files (i.e., everything has to be in memory).