View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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