Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
A.J A.J is offline
external usenet poster
 
Posts: 2
Default New Web Query Macro

Does anyone know how to setup excel to automatically search a web page and
then download data to an excel workbook on a daily basis?



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 110
Default New Web Query Macro

data(menu)-getexternaldata-new webquery
choose completepage, all the table or a spefific table
once this query is run subsequely you only refresh.
there is toolbar for external data
see help <get externaldata


--
remove $$$ from email addresss to send email
===================
A.J wrote in message
. ..
Does anyone know how to setup excel to automatically search a web page and
then download data to an excel workbook on a daily basis?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Query shakey1181 Excel Discussion (Misc queries) 3 July 24th 07 07:55 PM
another macro query - deleting a worksheet within a query DavidHawes Excel Discussion (Misc queries) 2 February 26th 07 10:05 AM
NEW WEB QUERY MACRO A.J Setting up and Configuration of Excel 0 July 24th 05 04:31 AM
best way to query during macro run mkingsley Excel Programming 1 May 24th 04 07:50 PM
Web Query in Macro buckle Excel Programming 0 August 19th 03 10:01 PM


All times are GMT +1. The time now is 01:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"