PC Review


Reply
Thread Tools Rate Thread

automating external data capture with a web query

 
 
analyst41@hotmail.com
Guest
Posts: n/a
 
      2nd Nov 2010
I know the URLs I want to capture (about 30 or so) repeatedly.

Is there a way of presetting all of them and carrying out the captures
with (ideally 1) few keystrokes?

Thanks.
 
Reply With Quote
 
 
 
 
Don Guillett Excel MVP
Guest
Posts: n/a
 
      2nd Nov 2010
On Nov 1, 8:27*pm, "analys...@hotmail.com" <analys...@hotmail.com>
wrote:
> I know the URLs I want to capture (about 30 or so) repeatedly.
>
> Is there a way of presetting all of them and carrying out the captures
> with (ideally 1) few keystrokes?
>
> Thanks.


If the sites allow scalping you can do this with a looping macro.
"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't capture video using external capture device =?Utf-8?B?c2xlZXB5?= Windows XP MovieMaker 1 17th Oct 2006 06:15 PM
Automating Get External Data >> Import justin.alford@gmail.com Microsoft Access External Data 1 28th Feb 2006 09:13 PM
automating get external data (from web) _Bigred Microsoft Excel Worksheet Functions 0 12th Jun 2005 10:25 PM
External Data Query, named table not available for query in copies =?Utf-8?B?QmF4dGVy?= Microsoft Excel Misc 3 16th Apr 2004 10:42 PM
Data\Import External Data\Edit Query 'grayed' out in Excel Steve Microsoft Excel Setup 0 7th Apr 2004 07:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:37 PM.