LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Query website from spreadsheet

I have used web queries before but never tried to do anything like
this...

I have a spreadsheet with a column of URL's. What I would like to do
is write a macro that can loop through the "URL" column and query each
website for the contents of the meta description tag and store that in
an adjacent cell.

i.e. A site with the tag: <META NAME="Description" CONTENT="Website
Description ." would return the text "Website Description"

I don't even know where to start...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Web Query for Java Applet driven data website mingInv Excel Discussion (Misc queries) 1 August 25th 10 06:14 AM
website prevents excel import web query steven Excel Discussion (Misc queries) 0 March 2nd 10 02:00 PM
Excel spreadsheet on website Gayle Excel Discussion (Misc queries) 0 March 5th 09 01:36 PM
nse website query Pradip Jain Excel Programming 2 April 12th 08 05:17 PM
How do I query a website bill Excel Programming 2 February 22nd 05 05:53 AM


All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"