HI,

Is it possible to operate upon the data held in an OLE object? Using you example spreadsheet, could it be possible to sum up the months sales on using a calculation on a form rather than in the excel spreadsheet itself?

Or would it require (and is this possible) some other vb code to extract the data and either append it to a table or store it as a temporary variable first (and isthat even possible to do?)?

---

Reply from Alex Hedley:

You can use operate on othe objects using VBA but it can get quite tricky.
Why not import the data into Access then work on it from there?
Check out Expert 20