Updating of VB script .
1 Check enclosed script. It collects data from an online database, and writes into excel sheet.
2 Adjust this script, lower part (Statens Byggtekniske etat) so that it collects additional data from same online dabatase. The additional data required are bussines category, organisation number, and zipcode.
Go to the URL to find businesscategory:
<[url removed, login to view]>
Search for the company *Mester-Rør* in search field ??Foretaksnavn?? on this URL
In the page you get when clicking *Mester-Rør*: Below the line you get this sentence: ??Mester-rør AS oppgir at foretaket utfører arbeider med egne ressurser innenfor følgende arbeidsområder: Rørinstallasjoner, Energi-installasjoner, Vannforsyning avløp og renseanlegg??
We need the first word “Rørinstallasjoner?? in this sentence written into excel file. ??Rørinstallasjoner?? is the bussinesscategory we are after.
3 We also need the field Organisasjonsnr: (top left) collected in the same way. (only number). And field zipcode; Forth line from top “9285 Trømsø?? Only number
4 All the data (included data collected by existing script) should be written into excel
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).