Macro automatic update

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

Guest

Hi,

I've created a spreadsheet that automatically updates stock quotes using
Import-Web query. Now I'm trying to create a Macro to update the info
automatically when I click on it. I've tried to create a Macro already by
clicking on "Refresh Data." When creating the macro, the stock info gets
updated but when I try to run the macro again there is a runtime error. Any
suggestions? Thanks,
 
I think putting it at the worksheet or workbook level would help. So anytime
you open up the workbook it automatically runs that macro and updates the
links.
 

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

Macro won't paste results 1
Excel 2007: Help creating a macro that will run Solver? 3
Automatic Conditional Formatting 1
Access Automatically Send a notification email once a record is added 0
Run Macro Automatically When Excel 2003 Opens 2
Create Macro to pull data from a warehouse management system? 1
writing a macro that automatically opens another file 3
macro showing and hiding detail 1

Back
Top