VBA Question

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:
Mappe1
ABCD
1StandartGroupProduktNameProduktNrPrice
2Druckerhersteller\Agfa\X25Toner6x150g+TB8916-402
3Druckerhersteller\Agfa\X310Toner4x650g401B
4Druckerhersteller\Agfa\X58Toner1x1500g1366a004
5Druckerhersteller\Agfa\X88Toner1x1500g1366a004
6Druckerhersteller\Alcatel\Fax3612ThermopapierFAX210x100x25
7Druckerhersteller\Alcatel\Fax3745Druckpatrone51626AE
8Druckerhersteller\Alcatel\Fax70BildtrommelFO-26DR
9Druckerhersteller\Alcatel\Fax70Tonerinkl.ChipTNR-250
10Druckerhersteller\Alcatel\Fax3735Druckpatrone51626AE
11Druckerhersteller\Alcatel\Fax3757DruckpatroneBC-20bk
12Druckerhersteller\Alcatel\Fax3757Druckkopfinkl.TintecolorBC-21e
13Druckerhersteller\Alcatel\Fax3757TintenpatroneschwarzBCI-21bk
14Druckerhersteller\Alcatel\Fax3757TintenpatronefarbeBCI-21c
15Druckerhersteller\Alcatel\Fax3740Druckpatroneschwarz51633ME
16Druckerhersteller\Alcatel\Fax55BildtrommelPK-12
17Druckerhersteller\Alcatel\Fax55Toner2St./VETK-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
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
Can you not just create an MSQuery and import the whole table with prices??

lenze
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,264
Office Version
  1. 365
Platform
  1. Windows
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,127,205
Messages
5,623,364
Members
415,969
Latest member
Rey99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top