N
Natalie
Hello,
I'm trying to work smarter. I want to learn how to create/use a macro to do
the following. I need to click on an IE link, cut and paste into Excel, and
return to the previous IE page, click the next link, cut and paste into Excel
slightly below the previous record, repeat for about 488 records. Any
suggestions?
The first page is:
http://cdec.water.ca.gov/cgi-progs/...ALAMEDA&operator=Alameda+County&display=staid
The second page is: (changing - that I cut and paste from)
http://cdec.water.ca.gov/cgi-progs/staMeta?station_id=ABR
Rinse, repeat 487 times more. Any suggestions?
Thank you.
Natalie Vane
916-631-4548
(e-mail address removed)
I'm trying to work smarter. I want to learn how to create/use a macro to do
the following. I need to click on an IE link, cut and paste into Excel, and
return to the previous IE page, click the next link, cut and paste into Excel
slightly below the previous record, repeat for about 488 records. Any
suggestions?
The first page is:
http://cdec.water.ca.gov/cgi-progs/...ALAMEDA&operator=Alameda+County&display=staid
The second page is: (changing - that I cut and paste from)
http://cdec.water.ca.gov/cgi-progs/staMeta?station_id=ABR
Rinse, repeat 487 times more. Any suggestions?
Thank you.
Natalie Vane
916-631-4548
(e-mail address removed)