info update from a webpage

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

Guest

How do you get information in an excel sheet to update every time you open up
the workbook.
I want certain numbers to be updated from a webpage when the information on
the webpage changes all the time. E.g stock quotes
 
Need,

Make a web query. Data - Import External Data - New Web Query. Then you need only refresh
it (right click in it and choose Refresh). Or set up a macro in the Workbook_Open sub to do
it automatically.
 
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

A Macro that Copies from Excel & Pastes into a webpage 1
Excel 'Back' Button 1
Invisible Link 4
Open Webpage in Excel 3
grabbing data from another website 1
How to change a pasted web link to hyperlink 1
Stopping copying from a webpage 1
Is this possible? 1

Back
Top