Open Webpage in Excel

B

Brian B.

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
 
G

GS

Brian B. explained on 4/27/2011 :
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
Click to expand...

Not sure why this is happening to you because I get the webpage in the
worksheet. (Tested in versions 9 thru 12)
 
B

Brian B.

Brian B. explained on 4/27/2011 :




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.
Click to expand...
The code to open the webpage in Excel is very straight forward:
Workbooks.Open Filename:="http://www.google.com" '[example]
Click to expand...
The top line of the information loaded in the worksheet is:
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head>
Click to expand...
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).
Click to expand...
Thanks,
-Brian
Click to expand...

Not sure why this is happening to you because I get the webpage in the
worksheet. (Tested in versions 9 thru 12)

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc- Hide quoted text -

- Show quoted text -
Click to expand...

I am using Excel 2007 and this hasn't happened before so its
incredibly frustrating. Any thoughts on any settings that I need to
change/update or references I need to add?
 
G

GS

Brian B. has brought this to us :
I am using Excel 2007 and this hasn't happened before so its
incredibly frustrating. Any thoughts on any settings that I need to
change/update or references I need to add?
Click to expand...

My XL2007 is pretty much 'right out of the box' so I don't know what
settings could be in play here. -Sorry!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL IN WEBPAGE 1
select open webpage, copy information to open worksheet 2
DisplyaAlerts Problem 2
Why is no viewState send to the Browser in this piece of aspx code 2
how to show (excel export)webpage in our LAN? 2
Very urgent help needed: Excel is still running after closing it! 2
html exported to excel when save as, defaults to web page 4
Force Character Encoding 9

Top