Macro automatic update
 

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

Macro automatic update
 

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.

"miteeka" wrote:

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

Macro automatic update
 

How exactly do you create this Macro?

marc
--
miteeka


"AKphidelt" wrote:

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.

"miteeka" wrote:

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