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
|