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?
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?
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 <[email protected]> wrote in message
news:[email protected]...
> 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?
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks