Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programmable Web Query
I am trying to pull back data from our company intranet
into a spreadsheet. The data resides in a browser of our printer meter readings(Copy Meter, Pages printed, Machine Total etc). It uses CentreWare Internet Services software that comes with Xerox print centers. I have tried modifying this code: Sub URL_Get_Query() With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://webservices.pcquote.com/cgi-" & _ "bin/excelget.exe?TICKER=msft", _ Destination:=Range("a1")) .BackgroundQuery = True .TablesOnlyFromHTML = True .Refresh BackgroundQuery:=False .SaveData = True End With End Sub by placing my url in it but it still doesn't work. The page uses frames and sometimes it brings back an error refering to frames. Should I create a macro or web query (which won't work either for me). Could someone please show how to either modify the code properly or how to do the proper web query. This is my first shot at it so please include detail or even someone who could help! I would be forever grateful!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programmable Web Query
Rhonda
Do a google search http://www.google.com/advanced_group_search?hl=en on web query frames in microsoft.public.excel.* -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "RCarroll" wrote in message ... I am trying to pull back data from our company intranet into a spreadsheet. The data resides in a browser of our printer meter readings(Copy Meter, Pages printed, Machine Total etc). It uses CentreWare Internet Services software that comes with Xerox print centers. I have tried modifying this code: Sub URL_Get_Query() With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://webservices.pcquote.com/cgi-" & _ "bin/excelget.exe?TICKER=msft", _ Destination:=Range("a1")) .BackgroundQuery = True .TablesOnlyFromHTML = True .Refresh BackgroundQuery:=False .SaveData = True End With End Sub by placing my url in it but it still doesn't work. The page uses frames and sometimes it brings back an error refering to frames. Should I create a macro or web query (which won't work either for me). Could someone please show how to either modify the code properly or how to do the proper web query. This is my first shot at it so please include detail or even someone who could help! I would be forever grateful!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programmable Column Sequencing? | Excel Discussion (Misc queries) | |||
Use MS Query to query data within the current work book | Excel Discussion (Misc queries) | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) |