VBA Code to grab data from website into MS excel -- 2
$30-250 USD
着払い
Problem:
I currently have a manual process I want to automate. The process consists of searching for listings on a specialty website and copying manually a field of information into excel. I tried using the function in excel to import data from External Website but the needed field couldn’t be imported ( It looks like it’s protected by the website).
Note: The website is secured and is coded in Java Script
Requirement:
I have a list of “Record Number” (unique identifier) in excel. Each record corresponds to a Sales Listing online. The user must login to the website before they can search for the listing corresponding the “Record Number”. After the listing info is displayed, there are 2 fields that needs to be copied from the listing back to the excel file next to the “Record Number”. This action must be done for hundreds of records at a time.
I need the macro/vba/Program to login to the website, search for the listing and grab the email address of the agent for each listing. The program should do the following:
1. Log into websie
2. Go to search page
3. Grab “Record Number” from Excel
4. Search for “Record Number” in website
5. Select Listing link
6. Copy email address
7. Paste it next to “Record Number” in Excel
8. Go to the next record and repeat until done with records
プロジェクトID: #7209333
プロジェクトについて
28人のフリーランサーが、平均$144 で、この仕事に入札しています。
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
Hello Sir - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am amo もっと
Hi Ready to start. Thanks ..................................................................................
Hi: It would be great if you could the website. This will allow me to gauge the complexity in the work. Please note that I have 100% completion rate and 5-star feedback on all projects (>50 total completed projects). M もっと
Hello, This is what probably most of developers write about them self: "Sir, I've done numerous projects like this..." "Sir, my team and I understand the requirements and we are ready to start right away..." "Si もっと
See my portfolio and reviews, contact me if you're interested. Thanks, _______________________________________________________
Hi, I am working as software professional in IT industry from last 4 years. I work on VB scripting along with VBA for MS office applications. Also developed various Desktop based application using Visual Studio もっと
Hello, I am interested in your offer and is ready to cooperate. I have experience in creating programs for entering information Excel. I have experience in data entry. To start I have to look at the site.
Hello sir, I am interested to collect data from website. I am ready for your interview. Also I will wait for this. Regards, Ananda
I have worked on VB apps in a software company on similar projects. We can use web scraping technique in VB to fetch the data from the web site and populate the excel sheet.
Hi .. I have very exposure in Visual basic and excel work , and I would like to work on this project my contact no : +919999503997