Daily Macro to Download Data, Order and paste in order  
Author Message
terpatwork





PostPosted: Wed Nov 17 05:55:04 CST 2004 Top

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.hide-link.com/ %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.hide-link.com/ ;userid=1656
View this thread: http://www.hide-link.com/

Excel417  
 
 
Tom





PostPosted: Wed Nov 17 05:55:04 CST 2004 Top

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



>
> 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?action=getinfo&userid=16566
> View this thread: http://www.excelforum.com/showthread.php?threadid=314259
>