AutoSave without editing, or calculating cells without change

L

Liz L :>) \)

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.
 
N

Norman Jones

Hi Liz,

Look at the Calculate method in VBA help,

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

Liz L :>)

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
 
N

Norman Jones

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.
Click to expand...

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
'<<---------------------------
 
L

Liz L :>)

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.
 
Top