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