I'm trying to automate repetitive steps. I have 2500 account numbers i
column "x" of an EXCEL 97 SR-1 worksheet running on Win 98 with 320 M
60% free. I'm trying to retreive the 2002, 2003 & 2004 assessed value
for each account and place them in the appropriate worksheet cells (o
the same line as the account number). So far, I've completed 13
accounts, but doing this step-by-step (below) seems wasteful. An
suggestions would be WELCOME!!
Steps:
1. Make sure Control Panel Internet Connection Privacy lever is set a
"medium" or below to allow cookies.
2. Find account number in cell $x140 in EXCEL Worksheet 1.
3. Open pwcgov.org/real estate/LandRover.asp
4. Drill down to "Assessment" screen.
5. Copy 2004 total value.
6. Retreive Excel Worksheet 1.
7. Go to cell $aa140.
8. Paste total value.
9. Retreive "Assessment" screen on the pwcgov.org/rea
estate/LandRover.asp web page.
10. Copy 2004 land value.
11. Retreive Excel Worksheet 1.
12. Go to cell $ab140.
13. Paste land value.
14. Retreive "Assessment" screen on the pwcgov.org/rea
estate/LandRover.asp web page.
15. Copy 2004 improvements value.
16. Retreive Excel Worksheet 1.
17. Go to cell $ac140.
18. Paste improvements value.
19. Retreive "Assessment" screen on the pwcgov.org/rea
estate/LandRover.asp web page.
20. Copy 2003 total value.
21. Retreive Excel Worksheet 1.
22. Go to cell $ad140.
23. Paste total value.
24. Retreive "Assessment" screen on the pwcgov.org/rea
estate/LandRover.asp web page.
25. Copy 2003 land value.
26. Retreive Excel Worksheet 1.
27. Go to cell $ae140.
28. Paste land value.
29. Retreive "Assessment" screen on the pwcgov.org/rea
estate/LandRover.asp web page.
30. Copy 2003 improvements value.
31. Retreive Excel Worksheet 1.
32. Go to cell $af140.
33. Paste improvements value.
34. Retreive "Assessment" screen on the pwcgov.org/rea
estate/LandRover.asp web page.
35. Copy 2002 total value.
36. Retreive Excel Worksheet 1.
37. Go to cell $ag140.
38. Paste 2002 total value.
39. Retreive "Assessment" screen on the pwcgov.org/rea
estate/LandRover.asp web page.
40. Copy 2002 land value.
41. Retreive Excel Worksheet 1.
42. Go to cell $ah140.
43. Paste land value.
44. Retreive "Assessment" screen on the pwcgov.org/rea
estate/LandRover.asp web page.
45. Copy 2002 improvements value.
46. Retreive Excel Worksheet 1.
47. Go to cell $ai140
48. Paste improvements value.
49. Highlight aa140 through ai140.
50. Select Format, Cell, Number, "General".
51. Select Format, Cell, Alignment, uncheck "wrap text"
Repeat for the next 2,360 accounts/lines, beginning on line 141!!

Is there any way to copy the keystrokes and mouse clicks that make u
any of the copy/paste/format steps already entered? If not, how do
overcome the absolute reference standard in the EXCEL macro recorder.
Where is the best place to "put" the macro? How do I invoke the macr
for each line?

Thread started in EXCEL Misc., also

--
Message posted from http://www.ExcelForum.com