Add data in an excelfile from a website - manually or with VB code

1. Open the file ”1500 kunder 2013-09-17” (this file is full of information about different companies) 2. Under column B called “Org-nr” you will enter some specific numbers. You will find these by going into www.foretagsfakta.se. Under Column A “Name” you will find the name of the company. Check the login info for the site [login to view URL] in the file [login to view URL] 3. Now that you are on [login to view URL] (see [login to view URL]) then you will enter the name of the company (use copy/paste CRTL+C and CTRL+V) in the textbox “Vad (tex branschnamn, företagsnamn, telefon, sökord)”. 4. After you have entered the company name in the textbox then you will click the button “Sök”. 5. Now you will see the company name in a form of a link (check [login to view URL]) – Click this link. 6. Now you will see a text called “Orgnr:” (check [login to view URL]) – Copy this number and paste into the row under Column “B” “Org-nr” 7. Do this for the whole excel file then send it back to me. 8. You can build a Visual Basic software that can do this automatically.