| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic update of spreadsheet & automatic update between workboo | Excel Worksheet Functions | |||
| Automatic Update | Charts and Charting in Excel | |||
| Automatic update | Excel Discussion (Misc queries) | |||
| Automatic Date Update | Excel Discussion (Misc queries) | |||
| automatic macro update | Excel Worksheet Functions | |||
Linear Mode
