Macro automatic update

M

miteeka

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,
 
A

AKphidelt

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.
 
Top