Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 14th 09, 10:07 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 6
Default Copy web page to Excel using VBA

Hi,
Attempts to code, in VBA, a means of copying a web page onto an Excel
sheet have been frustrating and inconclusive.
When I apply the "QueryTables.Add" approach using the URL, I get a
partial result but it does not include the data I wish to capture -
just static data.
If I use the "FollowHyperlink" approach, Internet Explorer is called
and the web page is displayed but I cannot see how to code in VBA,
"SellectAll" and "Copy" so that I can then "Paste" to the Excel
sheet. I have tried this approach in a manual manner using a list of
Hyperlinks and calling each Hyperlink, copying the web page and
pasting onto individual spreadsheets.
Can this be achieved using VBA?
TIA, Ken Rock

Reply
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
How do I copy page set up in Excel using VISTA Raquel Huelgas Excel Discussion (Misc queries) 1 April 1st 09 06:31 PM
How do I copy a paragraph from web page to excel file? Convert94 New Users to Excel 2 September 16th 08 04:09 PM
Excel won't copy a page within the workbook Larry Excel Discussion (Misc queries) 1 December 23rd 05 07:14 PM
Excel-copy first row onto each page ok but not last page How? Astro Excel Discussion (Misc queries) 1 June 22nd 05 07:27 AM
Macro that copy page to page just some filled cells LC Excel Discussion (Misc queries) 0 May 13th 05 11:22 PM


All times are GMT +1. The time now is 06:07 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017