ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA and internet (https://www.excelbanter.com/excel-programming/378161-vba-internet.html)

dr chuck

VBA and internet
 
Is it possible to have a macro go to a defined website and retrieve
information for your spreadsheet?

IE www.website.com
then copy and paste info into excel
--
dr chuck

Don Guillett

VBA and internet
 
Certainly. However, it can be even better than that
goto the websiteright click in a tableexport to microsoft excelafter the
new excel workbook opens it probably will be necessary to goto the upper
left of the resultsright click edit queryselect the table(s) you
wantimport. Then you can record a macro while doing a refreshclean it up
introduce variables, etc.


--
Don Guillett
SalesAid Software

"dr chuck" wrote in message
...
Is it possible to have a macro go to a defined website and retrieve
information for your spreadsheet?

IE
www.website.com
then copy and paste info into excel
--
dr chuck





All times are GMT +1. The time now is 08:40 AM.

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