VBA Question

[BBQ]

Hello community !

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

 

[lenze]

Can you not just create an MSQuery and import the whole table with prices??

lenze

 

[Norie]

BBQ

Couldn't you adapt the code I previously posted?

By the way why are you repeating printer manufacturer?

And where is the information, sans price, coming from in the first place?