VBA and internet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Certainly. However, it can be even better than that
goto the website>right click in a table>export to microsoft excel>after the
new excel workbook opens it probably will be necessary to goto the upper
left of the results>right click >edit query>select the table(s) you
want>import. Then you can record a macro while doing a refresh>clean it up>
introduce variables, etc.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alternative to web query in Excel 97? 1
Data exchange between macro and spreadsheet 1
Copy and Paste an HTM file with Vba 5
Link Not Embed Images from URL 1
Alt codes 4
vba powerpoint pasting named shape in selected named slides 0
VBA to copy an htm file into excel 4
VBA in Excel to read the VBA Code 1

Back
Top