Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Daily Macro to Download Data, Order and paste in order
Hi, I have recently start a macro to run on a daily basis. It is to tak data twice daily from an internet site and then intup this data to table in date order. Below is my macro thus far. It manages to get the data from th internet input the data on the first sheet(DO NOT CHANGE) of m workbook. I would then like to know if it is possible to input this data, using macro, every twelve hours into a table. Some time the data may come i missing soem or with a time step, therefore would like the data to b kept and updated in date and time order. Also while I am so busying picking your brains would like to know if i is posible to set this macro to run every twleve hours automaticly Thanks for your time and help Iarla Sub Macro1() Range("A2").Select Selection.Copy Application.CutCopyMode = False Workbooks.Open Filename:= _ "http://www.ndbc.noaa.gov/station_page.php?station=64046%3E" Range("C47:U68").Select Selection.Copy Application.DisplayAlerts = False ActiveWorkbook.Close Application.DisplayAlerts = True Windows("book2.xls").Activate Sheets("DO NOT CHANGE").Activate Range("A12").Select ActiveSheet.Paste End Su -- Iarl ----------------------------------------------------------------------- Iarla's Profile: http://www.excelforum.com/member.php...fo&userid=1656 View this thread: http://www.excelforum.com/showthread.php?threadid=31425 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Daily Macro to Download Data, Order and paste in order
Look at Chip Pearson's page on using Application.Ontime
http://www.cpearson.com/excel/ontime.htm Excel would have to remain open to use that approach. -- Regards, Tom Ogilvy "Iarla" wrote in message ... Hi, I have recently start a macro to run on a daily basis. It is to take data twice daily from an internet site and then intup this data to a table in date order. Below is my macro thus far. It manages to get the data from the internet input the data on the first sheet(DO NOT CHANGE) of my workbook. I would then like to know if it is possible to input this data, using a macro, every twelve hours into a table. Some time the data may come in missing soem or with a time step, therefore would like the data to be kept and updated in date and time order. Also while I am so busying picking your brains would like to know if it is posible to set this macro to run every twleve hours automaticly Thanks for your time and help Iarla Sub Macro1() Range("A2").Select Selection.Copy Application.CutCopyMode = False Workbooks.Open Filename:= _ "http://www.ndbc.noaa.gov/station_page.php?station=64046%3E" Range("C47:U68").Select Selection.Copy Application.DisplayAlerts = False ActiveWorkbook.Close Application.DisplayAlerts = True Windows("book2.xls").Activate Sheets("DO NOT CHANGE").Activate Range("A12").Select ActiveSheet.Paste End Sub -- Iarla ------------------------------------------------------------------------ Iarla's Profile: http://www.excelforum.com/member.php...o&userid=16566 View this thread: http://www.excelforum.com/showthread...hreadid=314259 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
download stationery order template | Excel Discussion (Misc queries) | |||
How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
Using a macro to sort your data in alphabetical order? | Excel Discussion (Misc queries) | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |