I am pulling data from another place which gets updated on save, however not
just save, something on the sheet appears to need to be updated. I have
written a Module which saves the sheet on a pre defined timed interval. The
procedure is working (without editing the sheet). But my data will not
update unless I manually change a cell anywhere on the sheet, then at the
next timed interval of Save, all my tags are updated. How do I Change a cell
(from within my code) each pass through the timer. I beleive if the cell
automatically updated right before the save command, then my data hopefully
will update also, as if I had manually changed the cell (I hope anyways).
The workbook is saving (with my procedure), yet it is not calculating the
cells upon save. PS - Thanks for auto timer (OnTime) to cpearson.

Hi Liz,

Look at the Calculate method in VBA help,

You can optionally, calculate a specific range, a specific worksheet or all
open workbooks.


---
Regards,
Norman


<Liz L : wrote in message
...
I am pulling data from another place which gets updated on save, however
not
just save, something on the sheet appears to need to be updated. I have
written a Module which saves the sheet on a pre defined timed interval.
The
procedure is working (without editing the sheet). But my data will not
update unless I manually change a cell anywhere on the sheet, then at the
next timed interval of Save, all my tags are updated. How do I Change a
cell
(from within my code) each pass through the timer. I beleive if the cell
automatically updated right before the save command, then my data
hopefully
will update also, as if I had manually changed the cell (I hope anyways).
The workbook is saving (with my procedure), yet it is not calculating the
cells upon save. PS - Thanks for auto timer (OnTime) to cpearson.

I can't get a hit on Calculate Method. If I hit the F9 (Calc Now) key when
in excel, it updates the sheet. There must be code which automates this.

Please help!

Thanks,

Liz

"Norman Jones" wrote:

Hi Liz,

Look at the Calculate method in VBA help,

You can optionally, calculate a specific range, a specific worksheet or all
open workbooks.


---
Regards,
Norman


<Liz L : wrote in message
...
I am pulling data from another place which gets updated on save, however
not
just save, something on the sheet appears to need to be updated. I have
written a Module which saves the sheet on a pre defined timed interval.
The
procedure is working (without editing the sheet). But my data will not
update unless I manually change a cell anywhere on the sheet, then at the
next timed interval of Save, all my tags are updated. How do I Change a
cell
(from within my code) each pass through the timer. I beleive if the cell
automatically updated right before the save command, then my data
hopefully
will update also, as if I had manually changed the cell (I hope anyways).
The workbook is saving (with my procedure), yet it is not calculating the
cells upon save. PS - Thanks for auto timer (OnTime) to cpearson.

Hi Liz,

I can't get a hit on Calculate Method. If I hit the F9 (Calc Now)
key when in excel, it updates the sheet. There must be code
which automates this.


Look at the Calculate method in VBA help,

From VBA help:

'---------------------------
Calculate Method

Calculates all open workbooks, a specific worksheet in a workbook, or a
specified range of cells on a worksheet, as shown in the following table.

To calculate Follow this example
All open workbooks Application.Calculate (or just Calculate)
A specific worksheet Worksheets(1).Calculate
A specified range Worksheets(1).Rows(2).Calculate
'<<---------------------------


---
Regards,
Norman



"Liz L :)" wrote in message
...
I can't get a hit on Calculate Method. If I hit the F9 (Calc Now) key when
in excel, it updates the sheet. There must be code which automates this.

Please help!

Thanks,

Liz

"Norman Jones" wrote:

Hi Liz,

Look at the Calculate method in VBA help,

You can optionally, calculate a specific range, a specific worksheet or
all
open workbooks.


---
Regards,
Norman


<Liz L : wrote in message
...
I am pulling data from another place which gets updated on save, however
not
just save, something on the sheet appears to need to be updated. I
have
written a Module which saves the sheet on a pre defined timed interval.
The
procedure is working (without editing the sheet). But my data will not
update unless I manually change a cell anywhere on the sheet, then at
the
next timed interval of Save, all my tags are updated. How do I Change
a
cell
(from within my code) each pass through the timer. I beleive if the
cell
automatically updated right before the save command, then my data
hopefully
will update also, as if I had manually changed the cell (I hope
anyways).
The workbook is saving (with my procedure), yet it is not calculating
the
cells upon save. PS - Thanks for auto timer (OnTime) to cpearson.

Norman -

You are my hero! I did ask for Calculate Method, and it came up with zero
hits. I did this from excel inside a VBA module and asked for help. Any
idea what I did wrong to not get what you got?

Thanks again, I appreciate thee extra help. I just learned about
programming in a class last week, so I am excited to find things on my own,
as it means I can do more on my own.

"Norman Jones" wrote:

Hi Liz,

I can't get a hit on Calculate Method. If I hit the F9 (Calc Now)
key when in excel, it updates the sheet. There must be code
which automates this.


Look at the Calculate method in VBA help,

From VBA help:

'---------------------------
Calculate Method

Calculates all open workbooks, a specific worksheet in a workbook, or a
specified range of cells on a worksheet, as shown in the following table.

To calculate Follow this example
All open workbooks Application.Calculate (or just Calculate)
A specific worksheet Worksheets(1).Calculate
A specified range Worksheets(1).Rows(2).Calculate
'<<---------------------------


---
Regards,
Norman



"Liz L :)" wrote in message
...
I can't get a hit on Calculate Method. If I hit the F9 (Calc Now) key when
in excel, it updates the sheet. There must be code which automates this.

Please help!

Thanks,

Liz

"Norman Jones" wrote:

Hi Liz,

Look at the Calculate method in VBA help,

You can optionally, calculate a specific range, a specific worksheet or
all
open workbooks.


---
Regards,
Norman


<Liz L : wrote in message
...
I am pulling data from another place which gets updated on save, however
not
just save, something on the sheet appears to need to be updated. I
have
written a Module which saves the sheet on a pre defined timed interval.
The
procedure is working (without editing the sheet). But my data will not
update unless I manually change a cell anywhere on the sheet, then at
the
next timed interval of Save, all my tags are updated. How do I Change
a
cell
(from within my code) each pass through the timer. I beleive if the
cell
automatically updated right before the save command, then my data
hopefully
will update also, as if I had manually changed the cell (I hope
anyways).
The workbook is saving (with my procedure), yet it is not calculating
the
cells upon save. PS - Thanks for auto timer (OnTime) to cpearson.