ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   transfer information from a site into excel (https://www.excelbanter.com/excel-discussion-misc-queries/2443-transfer-information-site-into-excel.html)

joe l

transfer information from a site into excel
 
How can I take daily information on a website amd link it to an excel
worksheet ?
I want this to be instead of cutting and pasting !



Don Guillett

One thing you can try is, in the body of the web site, right click and
download to excel. This creates a web query that you can modify.

--
Don Guillett
SalesAid Software

"joe l" <joe
wrote in message
...
How can I take daily information on a website amd link it to an excel
worksheet ?
I want this to be instead of cutting and pasting !





joe l



"Don Guillett" wrote:

One thing you can try is, in the body of the web site, right click and
download to excel. This creates a web query that you can modify.

--
Don Guillett
SalesAid Software

"joe l" <joe
wrote in message
...
How can I take daily information on a website amd link it to an excel
worksheet ?
I want this to be instead of cutting and pasting !




What if I only need part of the page ?


Don Guillett

This creates a web query that you can modify
After you get into exceldataimport external dataedit
--
Don Guillett
SalesAid Software

"joe l" wrote in message
...


"Don Guillett" wrote:

One thing you can try is, in the body of the web site, right click and
download to excel. This creates a web query that you can modify.

--
Don Guillett
SalesAid Software

"joe l" <joe
wrote in message
...
How can I take daily information on a website amd link it to an excel
worksheet ?
I want this to be instead of cutting and pasting !




What if I only need part of the page ?





All times are GMT +1. The time now is 10:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com