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

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