| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XLT and Internet | Excel Discussion (Misc queries) | |||
| Copies From The Internet | Excel Worksheet Functions | |||
| downloading from the internet | Excel Programming | |||
| Excel & internet | Excel Discussion (Misc queries) | |||
| Internet Connection | Excel Programming | |||
Linear Mode
