Hello Experts,
Could you help with this question. How do you write out the following
command within code? (This code will be embedded in the current
worksheet)

1) Open C:\Extract names.xls
2) Copy A1 (Name, ie. Joe), B1 (Beginning Date ie. Dec.1,2003), C1
(Ending Date, ie. Dec.5,2003), D1 (Number, ie. 105).
3) In the current worksheet, use the (Number) to match row A's header.
In this example, the (Number) of 105 is located in F1.
4) Once in column [F], go down to the corresponding beginning date and
paste {Name}s throughout the entire range including the ending date. In
this example, the beginning date of Dec.1,2003 is in cell [A10] and
ending date of Dec.5,2003 is in cell [A14]. So there should be Joe in
every cell from [A10] to [A14] inclusive.
5) When pasting the names, keep all of the current worksheet's existing
formats such as cell color backgrounds. Paste only the name.
6) Now within the (Names), go down to second cell and color fill cell
background as Yellow. Should be yellow in cell [A11].
7) Now from A11, count every 3rd cell and color fill background as
Green. Should be cell [A15].
8) Go to last cell within the {Name} range. In this example, it will be
cell [A15] again. Color fill background as Red, no matter what color
was there before.
9) Delete C:\Extract names.xls

Your help is greatly appreciate.

Thanks in advance,
Ricky

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!