By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,234 Members | 1,832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,234 IT Pros & Developers. It's quick & easy.

Opening a Report does not update OLE Excel object

P: n/a
(apologies for the cross-post.. im not normally in the habit of such things)
SHORT VERSION (for smart people in a hurry):

I need some way to programmatically cause the update of calculated cells,
contained within an Excel OLE object that is embedded on a report in my
database

LONG VERSION (incase i cant write a sumamry to save my life):

I have an Excel spreadsheet embedded in a report. The sheet displays a cell
grid of the current month, and after much messing around, managed to get it
to render the month on a 5-week basis, starting the cells on the correct day
and shading out any days not in the month (so for october 2003 that starts
on a wednesday, MON and TUE on the grid are shaded in..)
it's for employye time sheets kinda thing..

anyways.. it all hinges on the update of just one cell.. The top left of the
sheet contains a cell with the formula:

=DATE( YEAR(TODAY()), MONTH(TODAY()), 1 )

However, this cell (and all otehr calculated cells) are not recalculated
every time the report is run, but on some sort of whimsical basis depending
on if the OLE is Opened, saved, and the changes to the design of the report
are saved.

Is there any way i can programmatically cause the sheet to run an update
(something similar to the "Update Fields" function of a word document)?
I dont even mind if the user has to press a key, as i can tell them to do
that
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
i should have mentioned additionally, that the Excel sheet is an "Unbound
Object Frame" called 'OLEUnbound8' .. whatever this means, in terms of
referencing (i'm an after-creation maintainer of the database)

cheers
matt
Nov 12 '05 #2

P: n/a
TC
Check online help for UpdateOptions. Does that help?

HTH,
TC

matt <cj***@hotmail.com> wrote in message
news:bl**********@hercules.btinternet.com...
(apologies for the cross-post.. im not normally in the habit of such things)

SHORT VERSION (for smart people in a hurry):

I need some way to programmatically cause the update of calculated cells,
contained within an Excel OLE object that is embedded on a report in my
database

LONG VERSION (incase i cant write a sumamry to save my life):

I have an Excel spreadsheet embedded in a report. The sheet displays a cell grid of the current month, and after much messing around, managed to get it to render the month on a 5-week basis, starting the cells on the correct day and shading out any days not in the month (so for october 2003 that starts
on a wednesday, MON and TUE on the grid are shaded in..)
it's for employye time sheets kinda thing..

anyways.. it all hinges on the update of just one cell.. The top left of the sheet contains a cell with the formula:

=DATE( YEAR(TODAY()), MONTH(TODAY()), 1 )

However, this cell (and all otehr calculated cells) are not recalculated
every time the report is run, but on some sort of whimsical basis depending on if the OLE is Opened, saved, and the changes to the design of the report are saved.

Is there any way i can programmatically cause the sheet to run an update
(something similar to the "Update Fields" function of a word document)?
I dont even mind if the user has to press a key, as i can tell them to do
that

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.