Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating xHell worksheet in Vb, then applying it to OLE?

Status
Not open for further replies.

jfrost10

Programmer
Jun 3, 2001
2,004
CA
Hey gang,

Here's whats happening: I've created an excel spreadsheet from within vb code that just creates a file and saves it. However, I'd like the user to view it in an OLE excel object. How do I assign it though?! I have code that assigns the worksheet all teh information formatting, but how do I do

oleExcelObject = VBCreatedWorksheet
???

Thanks in advance,
Jack
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top