Re: Web Scraping with MSAccess?
- From: lyle <lyle.fairfield@xxxxxxxxx>
- Date: Tue, 11 Dec 2007 13:20:23 -0800 (PST)
On Dec 10, 9:41 am, ManningFan <manning...@xxxxxxxxx> wrote:
I'd like to write something that interacts with Epay so I can keep
track of my auctions, but I have no idea where to start. Can it be
done? If so, does anyone know where any sample code is? I'd assume
Epay won't let you connect to their data so it must be done via a
scrape function, but I've never done one and don't even know where to
start.
Any help would be appreciated.
One can get very invovled with this, and one can be very simple:
Dim IE As Object
Sub test()
IE_Initiate
CopyPage "http://cgi.ebay.com/ebaymotors/ORIGINAL-PRINT-AD-1960-LE-
HOT-CAR-RENAULT-
DAUPHINE_W0QQitemZ250167317170QQihZ015QQcategoryZ6762QQrdZ1QQssPageNameZWD1VQQcmdZViewItem"
IE_Terminate
End Sub
Sub IE_Initiate()
Set IE = CreateObject("InternetExplorer.Application")
End Sub
Sub CopyPage(ByVal vStrPage As String)
With IE
.Visible = True
.Navigate vStrPage
Do Until .ReadyState = 4
Loop
.execWB 17, 0
.execWB 12, 0
End With
End Sub
Sub IE_Terminate()
On Error Resume Next
IE.Quit
Set IE = Nothing
End Sub
On my computer this copies the text contents of the page to the
clipboard. I don't know what you want to do with the info so I stopped
there:
The clipboard contents are:
eBay home | Pay | Register | Sign in | Site Map | Community | Help
Search eBay Motors Advanced Search
Back to home page Listed in category: eBay Motors > Parts &
Accessories > Manuals & Literature > Car & Truck > Other Makes
ORIGINAL PRINT AD - 1960 LE HOT CAR RENAULT DAUPHINE Item number:
250167317170
Buyer or seller of this item? Sign in for your status Watch this
item in My eBay
This item has been added to My eBay for Guests.
As a guest, you can:
Track up to 10 items on this computer in My eBay
Receive an email reminder for this item a few hours before it ends
View larger picture
price: US $4.99 Buy It Now >
--------------------------------------------------------------------------------
Shipping costs: US $2.50
US Postal Service First Class Mail(R)
Service to United States
Ships to: Worldwide
Item location: Charlotte, vicinity, United States
--------------------------------------------------------------------------------
You can also:
Bid with Bid Assistant
Get mobile or IM alerts | Email to a friend
Listing and payment details: HideShow
Payment methods: PayPal,
Personal check,
Money order/Cashiers check,
Other - See Payment Instructions for payment methods accepted
See details
Meet the seller
Seller: carolinaracer( 6015)
Feedback: 99.7% Positive
Member: since Apr-05-99 in United States
See detailed feedback
Ask seller a question
Add to Favorite Sellers
View seller's other items: Store | List
Visit seller's Store:
carolinaracer
Contact the seller instantly
Buy safely
1. Check the seller's reputation
Score: 6015 | 99.7% Positive
See detailed feedback
2. Check how you're protected
Description
carolinaracer
Visit my eBay Store:carolinaracer
ORIGINAL PRINT AD - 1960 LE HOT CAR RENAULT DAUPHINE
This is an original vintage ad - not a reprint. It is approx. 8" X 11"
& in great condition.
Buyer pays $2.50 shipping which includes delivery confirmation.
PLEASE READ BEFORE BIDDING :
We now accept PayPal. It's not really our preferred method. However,
you must have a PayPal confirmed address. In order for you to receive
discounted, combined shipping you must wait for a combined invoice ( &
let us know ) in other words - You must make only 1 payment to receive
shipping discount - no exceptions!!!!
----------------------------------------------------------------------------------
INTERNATIONAL BIDDERS: You are welcome to bid.Please do not expect
shipping to be the same outside of the US. If you do not have an
address within the US, I will email the shipping charges the day
following the auction close. I will take the package to the post
office & get the economy as well as air charges & then send you an
invoice.It will be your choice. US FUNDS ONLY & NO PERSONAL CHECKS
OUTSIDE THE US!!!
If you opt for no insurance we will not be responsible for loss or
damage.
PLEASE USE EBAY'S CHECKOUT!!!!!!!!!
It will provide you all the information you need including total &
address.
BID WITH CONFIDENCE - WE ARE PROUD TO BE EBAY POWERSELLERS!
PLEEESE include the auction number with your payment!!! It could
otherwise slooooooow down your shipment!!!!!! Personal checks must
clear before shipping.
We will combine shipping for multiple winners.
We will leave feedback for everyone that leaves it for us.
We leave feedback only once per week, usually Sunday mornings!
If you are a non-paying bidder, please expect a non-paying bidder
alert to be filed & NEGATIVE feedback!!!!
Payment must be received within 10 days of close of auction.
We will e-mail you, usually on the morning after, that your item has
shipped. If you want to receive this email, please check your spam
filter.
Thanks for bidding & good luck!!
Powered by eBay Turbo Lister
--------------------------------------------------------------------------------
00024
Free Credit Report & Score From Experian. Learn more.
Shipping and handlingShips to
Worldwide
Country: Show all available
Shipping and Handling To Service
US $2.50 United States US Postal Service First Class Mail(R)
2 to 5 business days*
Country: Show all availableUnited States
Shipping and Handling To Service
US $2.50 United States US Postal Service First Class Mail(R)
2 to 5 business days*
*Sellers are not responsible for service transit time. This
information is provided by the carrier and excludes weekends and
holidays. Note that transit times may vary, particularly during peak
periods.
Shipping insurance
US $2.00 Optional
Return policyReturn policy not specified.
Read item description for any reference to return policy.
Payment details
Payment method
Personal check
Money order/Cashiers check
Other - See Payment Instructions for payment methods accepted
Helpful information
eBay recommended services
HelpTake action on this item
Item title: ORIGINAL PRINT AD - 1960 LE HOT CAR RENAULT DAUPHINE
Buy It Now
price: US $4.99
Buy It Now > You will confirm in the next step.
--------------------------------------------------------------------------------
Purchase this item now without bidding. Learn about Buy It Now.
Other options
Back to home page | Report this item | Printer Version | Sell
one like this
Seller assumes all responsibility for listing this item.
About eBay | Announcements | Security Center | Buyer Services &
Protection | Policies | Site Map | Help
Copyright (c) 1995-2007 eBay Inc. All Rights Reserved. Designated
trademarks and brands are the property of their respective owners. Use
of this Web site constitutes acceptance of the eBay User Agreement and
Privacy Policy.
.
- Follow-Ups:
- Re: Web Scraping with MSAccess?
- From: Stuart McCall
- Re: Web Scraping with MSAccess?
- References:
- Web Scraping with MSAccess?
- From: ManningFan
- Web Scraping with MSAccess?
- Prev by Date: Re: Help with code
- Next by Date: weired behavor
- Previous by thread: Re: Web Scraping with MSAccess?
- Next by thread: Re: Web Scraping with MSAccess?
- Index(es):
Relevant Pages
|
