VBA Code to grab data from website into MS excel -- 2

完了済み 投稿 Feb 26, 2015 着払い
完了済み 着払い

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個の提案 リモートプロジェクト アクティブ Feb 27, 2015

アワード:

mhmhz

Hi Rather than Excel, i can provide desktop application that will do the automation. ---- Bid updated, i will deliver the following: 1. Desktop application run in Windows. 2. Set login option 3. Import record# もっと

$175 USD 0日以内
(94レビュー)
6.7

28人のフリーランサーが、平均$144 で、この仕事に入札しています。

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$250 USD 2日以内
(269件のレビュー)
7.2
fhasanbd

A proposal has not yet been provided

$211 USD 5日以内
(131件のレビュー)
6.5
jaylancer43

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 もっと

$210 USD 5日以内
(116件のレビュー)
6.3
hwanghendra

Hi Ready to start. Thanks ..................................................................................

$188 USD 3日以内
(218件のレビュー)
6.2
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 225 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive もっと

$150 USD 7日以内
(65件のレビュー)
5.8
gangabass

A proposal has not yet been provided

$222 USD 3日以内
(112件のレビュー)
5.7
aarifakhtar

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 もっと

$250 USD 7日以内
(47件のレビュー)
5.6
adityasl

I can do it with VBA and iMacros combination. Thanks

$67 USD 2日以内
(70件のレビュー)
4.8
salih0vicx

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 もっと

$110 USD 3日以内
(7件のレビュー)
4.7
tomislav1975

See my portfolio and reviews, contact me if you're interested. Thanks, _______________________________________________________

$222 USD 5日以内
(25件のレビュー)
4.7
abhinovpankaj

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 もっと

$122 USD 3日以内
(12件のレビュー)
4.0
naseefo

Hi there! I am a doctoral research scholar working at the Indian Institute of Technology (IIT) Delhi. I have previous experience in executing a similar project, in which, I had to get details various car spare parts もっと

$277 USD 7日以内
(4件のレビュー)
3.0
MykolaDudych

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.

$55 USD 3日以内
(2件のレビュー)
2.3
Vlzinch

Hello! I work with excel VBA for last for years and create more then 300 macro, i already have projects similar to yours ( i can show u example), one of them U can see at my profile ( betfair scrapping) so i can do もっと

$111 USD 3日以内
(2件のレビュー)
2.0
vw6897639vw

A proposal has not yet been provided

$40 USD 3日以内
(2件のレビュー)
0.9
atifarzi

Excel based grabbing of online data requires you to log in each time when searching for results, a better way can be using a professional scraper like Outwit Hub. But in case you want to do it using excel without spend もっと

$30 USD 7日以内
(2件のレビュー)
1.0
EXPERTarea

Hello sir, I am interested to collect data from website. I am ready for your interview. Also I will wait for this. Regards, Ananda

$100 USD 3日以内
(レビュー1件)
0.4
sunil7066

I am Data Entry/Data Processing Expert having experience of over twenty years who knows the value of time, very hard working and always deliver work on time. My Motive is to make my employer Happy without adding additi もっと

$155 USD 3日以内
(0件のレビュー)
0.0
RaghavendravDesh

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.

$166 USD 5日以内
(0件のレビュー)
0.0
raajanpandey

Hi .. I have very exposure in Visual basic and excel work , and I would like to work on this project my contact no : +919999503997

$155 USD 2日以内
(0件のレビュー)
0.0