ExcelBanter - Open Webpage in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Open Webpage in Excel (https://www.excelbanter.com/excel-programming/444498-open-webpage-excel.html)

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

Open Webpage in Excel

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

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 at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Open Webpage in Excel

On Apr 27, 8:38*pm, GS wrote:
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

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 -

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?

Open Webpage in Excel

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?

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

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc