Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording data from refreshing, imported sheets
:: Hi there, Looking for HELP on VB code for the following: I need to record data from dynamic , refreshing imported sheets t 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 Rang 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:J1 and J20:J33 respectively. iv) For every consecutive 180 minutes, records will be copied t consecutive cells on sheet Sr1 such as ............................................data in cells M4:M17 an 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 sheetr1, I have a [ =NOW() ] can I also have the exact time of every recording be placed a J3 ( K3, L3, M3, N3, .) of sheet Sr1 ? vi) I have about 8 ~ 10 imported sheets set to refresh at almost th 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 th completion of the other ? Thanks in advance for any assistance. EduardoD. 2004-10-10 : -- EduardoDo ----------------------------------------------------------------------- EduardoDon's Profile: http://www.excelforum.com/member.php...nfo&userid=849 View this thread: http://www.excelforum.com/showthread.php?threadid=26798 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording data from refreshing, imported sheets
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forumal writing for imported sheets | Excel Discussion (Misc queries) | |||
Refreshing ODBC data on Protected Sheets | Excel Discussion (Misc queries) | |||
MACRO recording to be for all new sheets | Excel Worksheet Functions | |||
MACRO recording to be for all new sheets | Excel Worksheet Functions | |||
Prevent certain tabs/sheets from refreshing | Excel Discussion (Misc queries) |