Comments:
You are trying to create an Excel spreadsheet which will update at a specific time each day.
I suggest that you use VBA’s OnTime method.
To learn how to use this procedure, just type OnTime in the Visual Basic Editor and press F1. This opens Visual Basic help on the OnTime method. For example, the line of code you would use to update your worksheet at 5:00 PM woruld be:
Application.OnTime TimeValue("17:00:00"), "my_Procedure"
The my_procedure which would be called by the OnTime method would contain the macro code which would manipulate the worksheet or the data you want updated.
I have used the OnTime method to update prices and write the values to a database. If you experience problems with the #NA values not clearing when you open a workbook, how to solve this problem is discussed in a previous Willow Talk. Check out the Willow Talk labeled Live Data in Excel.
Hope this helps.
|
