| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving an Embedded Excel Sheet in OLE Control
Hi,
I have an Excel Sheet that gets embedded within an OLE Control on my VB Form.The Sheet gets displayed perfectly but i am unable to save changes to the sheet back to the same file. Here is the piece of code that embeds the excel sheet on the VB Form : OLE1.Class = "Excel.Sheet.8" OLE1.Action = OLE_CREATE_EMBED OLE1.CreateEmbed ("C:\PivotTableReports\SalesAnalysis.xls") The embeded Worksheet contains a PivotTable Any thoughts on this. thanks prabhakar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedded Chart in Excel Sheet | Charts and Charting in Excel | |||
| Saving embedded object to disk | Excel Programming | |||
| Sorting embedded fields - control box | Excel Programming | |||
| Enabling a Embedded Control | Excel Programming | |||
| Enabling a Embedded Control | Excel Programming | |||
Threaded Mode
