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: 12
Default Open Webpage in Excel

I have created a couple macros that open internet webpages in Excel
and analyze the content of the page but for some reason the webpage no
longer loads on the worksheet and I am getting the html code.

The code to open the webpage in Excel is very straight forward:
Workbooks.Open Filename:="http://www.google.com" '[example]

The top line of the information loaded in the worksheet is:
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
<html<head

Any help getting the actual webpage to load in Excel would be greatly
appreciated (I am assuming I need to add a reference or change a
simple setting).

Thanks,
-Brian
 
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
Open Webpage and Extrat data based on list in excel TXDalessandros Excel Programming 5 September 8th 08 02:57 PM
select open webpage, copy information to open worksheet Kevin Excel Programming 2 September 5th 06 05:10 AM
Cannot Open Webpage With Excel 2003 rdshadden Excel Discussion (Misc queries) 0 May 25th 06 05:59 AM
Open a webpage using Javascript in Excel [email protected] Excel Programming 5 January 17th 06 09:05 PM
Open webpage Tom Ogilvy Excel Programming 0 July 22nd 04 05:28 PM


All times are GMT +1. The time now is 03:03 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"