View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
miteeka miteeka is offline
external usenet poster
 
Posts: 10
Default 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