Create a Macro that Data mines a web page without any tables

Budget $250 - $750 USD
Bids 13
Average Bid $352

I am trying to create a data mining macro in excel that will let me get information from a webpage ([url removed, login to view]). The proble is that the web page does not use tables, rather the code uses standard HTML coding.

The second problem is that there are levels and each level has several pages for example:
Level 1: State Names ([url removed, login to view]
Level 2: After selecting a state i might have to select a general regon ex:
[url removed, login to view]+Capital&id=DF
Gives me the choice between: Caracas, El Junkquito
Level 3: Lets say i select Caracas, then a face the alfabet list (i want all of them) but for example lets select the leter A.
Level 4: This opens a web page with two colums of names and about 46 others that are linked at the bottom (page 1,2, 3 etc.)
Level 5: Lets grab the first name, that sends me to another page where i have the information i want to get to. This page has Name, telefon, zone (might be missing) and state.
In this page there might be 1 to [url removed, login to view] names but only 15 will be showing at any giving time per page so the macro will have to crawl to get to the information.

Can anyone help me?

Post a Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • petrovp Profile Picture

    petrovp

    Vilnius,  Lithuania

    I am a programmer experienced in MS Excel, Visual Basic, PHP, MySQL, Javascript. I have completed many programming projects over the past few years at freelancer.com. Please view my freelancer profile at https://www.freelancer.com/u/petrovp.html Also I worked at Odesk - please view profile at https://www.odesk.com/users/~01c2b38101daa3f92d. I have enough free time now to work again. Please contact me and let's start working.

    PHP, Java, Javascript, and Adobe Flash

  • amitjamuda Profile Picture

    amitjamuda

    Calcutta,  India

    I am expert in data analytics, trend forecasting, data mining, automating with VBA and MT4.

    Visual Basic, Data Processing, Project Management, and Data Entry

  • shyjasek Profile Picture

    shyjasek

    ponniakurssi,  India

    Data Entry, Excel, XXX, and MLM

  • samsgates Profile Picture

    samsgates

    chennai,  India

    Computer science position utilizing solid training and experience in computer programming, data management, software development, web site design, and systems operations. for more info: http://net5.us/sam

    XML, Visual Basic, Internet Marketing, and Data Processing

  • Krusche Profile Picture

    Krusche

    Munchen,  Ukraine

    Specialties: Krusche&Co expertise is proven by the best practices and allows for the optimal solutions in terms of the choice of technological approach versus timing and budget. * Java, J2EE, JSP, Servlets, Portlets, Swing, Applets * MySQL, Oracle * HTML, DHTML, JavaScript, AJAX, XML, XSL, XSLT, jQuery, xQuery * Microsoft Windows / Linux During the last 2 years we have been active mostly in complex VBA programming which we use extensively for various purposes internally. K&C has extensive experience in the implementation of corporate web portals. Through our best practice we can implement tailor-made solutions at highly competitive prices. * Analysis of your requirements * Design of the solution, as can best be implemented with Liferay * Configuring Liferay * Implement the solution-specific portlets * Enlargement of the Liferay installation Service-Offering-Portfolio Liferay Themes (+embedding portlets in the theme and layouts) Development in plugin environment: * Struts, Spring MVC framework, Icefaces backed by Spring injection + Liferay-like service layer + Hibernate * Using Portal classloader and not using portal classloader * Hooks plugins (+ customized languages) Development in EXT environment: Layering different EXT environments (like modules where each one contains fully structured ext environment) and merging configuration files (spring, hibernate, liferay configs, languages, portal-ext.properties, etc...) * Extending liferay services and actions * Services Builder - managed persistance and service layer. * Ajaxed frontend * Interaction with Liferay core services: o Resources and permissions o Social activities actions o Tags and categories o Ratings and Comments o Adding custom entities to search index Configuration management * Performance tuning and metering * Clustering

    C Programming, Java, JSP, and Javascript

  • srinichal Profile Picture

    srinichal

    hyderabad,  India

    Perfection and dedication are the way we deal with projects on freelancer. There have been many clients all over the world that are satisfied with the solutions provided.All types of automation works along with web based solutions are our expertise. Looking to provide solutions in the Mobile markets as well. Some of the automation tools are listed in portfolio and here as well: * AutoBidder tool for Madbid like sites * Automation tools For all emails and social Bookmark sites * Social Bookmarking tools * Facebook Likes Automation * Webbased Versions of tools tailored to custom needs * Desktop apps tailored to customer needs * Proxy tools tailored to your requirements. A dedicated team that can literally deliver any project solution with high expertise. Please don't hesitate to contact us via freelancer. Satisfaction guaranteed solutions delivered all over the world. The Skill Set ranges from C# to PHP, Iphone to Andriod. We can deliver almost any solutions for your needs. We can also take up any type of work based on web design to desktop or mobile in the broad spectrum as we always strive to learn and perfect.

    PHP, Perl, Java, and JSP

  • ineedWorkJob Profile Picture

    ineedWorkJob

    Jessore,  Bangladesh

    I'm an expert developer (Windows Desktop Software & Web). I also do many others task like: - data mining - photo/image editing - data scraping - web automation - etc. For more, please check my skill set. :)

    PHP, ASP, C Programming, and Java

  • vbexcel Profile Picture

    vbexcel

    London,  Canada

    I am an independent Excel expert assisting my clients to unleash the power of Microsoft Excel for their personal productivity, professional advancement, profit and fun. Whatever the project, I can provide my services within your budget and deadlines. I can automate solutions with Visual Basic for Applications (VBA), integrate Excel with all other Office programs, Windows applications, popular APIs and other scripting languages. Also I can develop internet research, data mining, web scraping, and mash up applications - all powered by Excel and VBA. I can convert spreadsheets and workbooks into powerful business and time-saving tools, sophisticated financial models, compelling business plans, inquisitive and comprehensive reporting methodologies and into platforms for fun and profit. From the sophisticated to the mundane, no project is too big or too small not to get my personal touch and attention to detail that it deserves.

    Javascript, XML, Python, and Visual Basic

  • fBGp100 Profile Picture

    fBGp100

    Bangladesh

    Data Entry

  • vserv Profile Picture

    vserv

    Visakhapatnam,  India

    - 8 years in IT-cum-Data Processing companies Project Management Professional certified from PMI, USA - experience on following using Excel/VBA = OAuth = using APIs = JSON processing

    PHP, Visual Basic, Data Processing, and Project Management