• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 180
  • Last Modified:

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?
0
GivenRandy
Asked:
GivenRandy
  • 2
  • 2
1 Solution
 
GrahamSkanRetiredCommented:
You can always put it in an OLE Container control. Also, I have noticed others recommend using a WebBrowser control and putting it in that
0
 
GivenRandyAuthor Commented:
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).
0
 
GrahamSkanRetiredCommented:
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.
0
 
GivenRandyAuthor Commented:
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).
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now