hi,
look up OnTime Method time in
vb help.
see the following sites.
http://www.enhanceddatasystems.com/E...ExcelTimer.htm
http://www.mvps.org/dmcritchie/excel/datetime.htm
http://www.cpearson.com/excel/events.htm
http://www.rondebruin.nl/copy5.htm
-----Original Message-----
::
Hi there,
Looking for HELP on VB code for the following:
I need to record data from dynamic , refreshing imported
sheets to
other sheets as record on various time intervals.
Say,
i) 'r1' is an imported sheet refreshing every 60
minutes ;
set by ---- Data Import External Data Data Range
Properties Refresh every 60 minutes
ii) 'Sr1' is a recording sheet in match with
sheet 'r1';
iii) Need to transfer/record cells M4:M17 and N4:N17
to cells J4:J17
and J20:J33 respectively.
iv) For every consecutive 180 minutes, records will be
copied to
consecutive cells on sheet 'Sr1' such as
............................................dat a in
cells M4:M17 and
N4:N17 of sheet 'r1'
......60 minutes after :.......copied to cells K4:K17
and K20:K33
respectively on sheet 'Sr1';
2 x 60 minutes after :.......copied to cells L4:L17
and L20:L33
respectively on sheet 'Sr1';
3 x 60 minutes after :.......copied to cells M4:M17
and M20:M33
respectively on sheet 'Sr1';
and so on for 24 hours (i.e. 24 records)
Would appreciate help with appropriate VB code to do the
job.
v) at cell Q4 of sheet'r1', I have a [ =NOW() ]
can I also have the exact time of every recording be
placed at
J3 ( K3, L3, M3, N3, ..) of sheet ' Sr1' ?
vi) I have about 8 ~ 10 imported sheets set to refresh
at almost the
same time.
Obviously there will be some hindrances if all of them
refresh /
record simultaneously.
Will there be any VB code telling them to DO one after
the
completion of the other ?
Thanks in advance for any assistance.
EduardoD.
2004-10-10
::
--
EduardoDon
---------------------------------------------------------
---------------
EduardoDon's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=8492
View this thread:
http://www.excelforum.com/showthread...hreadid=267988
.