BBQ
New Member
- Joined
- Aug 22, 2007
- Messages
- 9
Hello community !
This is something for the advanced users. Here is the Problem:
My Table contains 13000 Articles which looks like this:
Now everything is fine so far, but the PRICE is missing as u can see.
I need the original Prices in the row"D". (Prices from www.tonermaus.de)
This is what this makro should do:
Cant write it in VBA myself, but here are the steps as i think:
1. Go to a URL
http://www.tonermaus.de/main_02.asp?sid={93E09ADA-85E3-4896-93D3-2163BECA1296}&login=&nav01=32
2. Click each link on this page and copy the Price field from their table to row "D" in my table.
3. Here comes the trick : It should of course fit the article number which is given in both tables (my table = row "C")
Can somebody help me out on this one ?
Best regards,
BBQ
This is something for the advanced users. Here is the Problem:
My Table contains 13000 Articles which looks like this:
Mappe1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | StandartGroup | ProduktName | ProduktNr | Price | ||
2 | Druckerhersteller\Agfa\X25 | Toner6x150g+TB | 8916-402 | |||
3 | Druckerhersteller\Agfa\X310 | Toner4x650g | 401B | |||
4 | Druckerhersteller\Agfa\X58 | Toner1x1500g | 1366a004 | |||
5 | Druckerhersteller\Agfa\X88 | Toner1x1500g | 1366a004 | |||
6 | Druckerhersteller\Alcatel\Fax3612 | Thermopapier | FAX210x100x25 | |||
7 | Druckerhersteller\Alcatel\Fax3745 | Druckpatrone | 51626AE | |||
8 | Druckerhersteller\Alcatel\Fax70 | Bildtrommel | FO-26DR | |||
9 | Druckerhersteller\Alcatel\Fax70 | Tonerinkl.Chip | TNR-250 | |||
10 | Druckerhersteller\Alcatel\Fax3735 | Druckpatrone | 51626AE | |||
11 | Druckerhersteller\Alcatel\Fax3757 | Druckpatrone | BC-20bk | |||
12 | Druckerhersteller\Alcatel\Fax3757 | Druckkopfinkl.Tintecolor | BC-21e | |||
13 | Druckerhersteller\Alcatel\Fax3757 | Tintenpatroneschwarz | BCI-21bk | |||
14 | Druckerhersteller\Alcatel\Fax3757 | Tintenpatronefarbe | BCI-21c | |||
15 | Druckerhersteller\Alcatel\Fax3740 | Druckpatroneschwarz | 51633ME | |||
16 | Druckerhersteller\Alcatel\Fax55 | Bildtrommel | PK-12 | |||
17 | Druckerhersteller\Alcatel\Fax55 | Toner2St./VE | TK-12 | |||
Tabelle1 |
Now everything is fine so far, but the PRICE is missing as u can see.
I need the original Prices in the row"D". (Prices from www.tonermaus.de)
This is what this makro should do:
Cant write it in VBA myself, but here are the steps as i think:
1. Go to a URL
http://www.tonermaus.de/main_02.asp?sid={93E09ADA-85E3-4896-93D3-2163BECA1296}&login=&nav01=32
2. Click each link on this page and copy the Price field from their table to row "D" in my table.
3. Here comes the trick : It should of course fit the article number which is given in both tables (my table = row "C")
Can somebody help me out on this one ?
Best regards,
BBQ