| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open Webpage and Extrat data based on list in excel | Excel Programming | |||
| select open webpage, copy information to open worksheet | Excel Programming | |||
| Cannot Open Webpage With Excel 2003 | Excel Discussion (Misc queries) | |||
| Open a webpage using Javascript in Excel | Excel Programming | |||
| Open webpage | Excel Programming | |||
Hybrid Mode
