Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Spreadsheet component in an ActiveX dll
Is it possible to use the office spreadsheet component
without having a userform to place the component on? I would like to make calculations on the server instead of on the clients. My server code constitutes of different ActiveX dll-s. I would like to populate the spreadsheet component with data from a recordset from my SQL200 database. In the spreadsheet I would calculate a lot of formulas that is also coming from the databse. Then I would like to get the result in XML from the component. The data then will be selected and parts of it sent to the client where XML then populates Excel2002 and the figures are shown on the client. Is this possible to accomplish? If yes where can I get some code examples to get some ideas. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activex component can't create object | New Users to Excel | |||
Use Office spreadsheet component in a ActiveX dll | Excel Programming | |||
Export method question -- Spreadsheet ActiveX component on user form | Excel Programming | |||
ActiveX component can't be created | Excel Programming | |||
activex component can't create object with SAP 6.20 | Excel Programming |