Microsoft Office Spreadsheet 11.0 ActiveX Control

[matt753]

No worries, sounds good

[ADezii]

No worries, sounds good

This is what I came up with matt753:

1. The XML Spreadsheet can easily be Imported into the ActiveX Control embedded within a Form.
2. In the above context, any changes that you make within the Spreadsheet Control are only available during the Current Session only and will not be in 'Sync' with the original XML Data.
3. To Save any changes to the Data in the Control within your Access Form, click the Export to Microsoft Excel Button on the Spreadsheet Toolbar.
4. The ActiveX Spreadsheet Control does expose an Updated() Event that is activated each time that a Cell is either Updated or Written to. I see no reason why you could not use Automation Code to write the Data back to the original Spreadsheet, but then it would have to be Re-Imported into the Control again once the DB is opened.
5. This is probably not what you wanted to hear, but it is what I have come up during my brief analysis of this Control.
6. You can probably expand on this information yourself should you so desire.

[matt753]

The ActiveX Spreadsheet Control does expose an Updated() Event that is activated each time that a Cell is either Updated or Written to. I see no reason why you could not use Automation Code to write the Data back to the original Spreadsheet, but then it would have to be Re-Imported into the Control again once the DB is opened.

I think the "auto refresh data from URL at run time" checkbox would take care of the updating from the file from the looks of things. What would the code be to write back to the XML file in the Updated Event?

[ADezii]

I think the "auto refresh data from URL at run time" checkbox would take care of the updating from the file from the looks of things. What would the code be to write back to the XML file in the Updated Event?

It would essentially be recreating the Spreadsheet and copying the Data to the newly created one.

[matt753]

Hmm maybe this isnt the best way to do what i'm trying to do then if you cant save back you the same one every time.


Are there any other ways I can integrate spreadsheets into my database?