You have chosen to sponsor your bid up to a maximum amount of .
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.
3. Now that you are on www.foretagsfakta.se (see screen.jpg) 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 screen2.jpg) – Click this link.
6. Now you will see a text called “Orgnr:” (check screen3.jpg) – Make sure that the Visual Basic code that you make in a new VB-project can Copy this number and paste into an array in the VB-code, becauase it will then later be entered and saved into the file "1500 kunder 2013-09-17"
I have attached the password and login details for www.foretagsfakta.se and the excelfile and a bit of VB-code that is used to open all the information in the excelfile and load into an array.