Refresh Morningstar Data at Specific Time

[A10hammond]

I am working to refresh morningstar data in an excel 2016 file, and I found the following code online on the Morningstar VBA guide:

Public dTime As Date
Dim lNum As Long
Sub RunOnTime()
dTime = Sheet1.Cells(1, 1) 'change the cell reference here (Row #, Column #)
Application.OnTime dTime, "RunOnTime"
Set cmd = Application.CommandBars("Cell").Controls("Refresh All")
cmd.Execute
End Sub

The guide says that this will refresh the data at 10:01:00 AM everyday, what do I change do make this refresh at 9:00 AM everyday? Also, if it refreshes everything does the cell reference matter?

Thanks.

 

[Yongle]

The time that the macro will run is determined by this line

dTime = Sheet1.Cells(1, 1)

ie currently set to the value in cell A1 in the FIRST sheet in the workbook
Enter value 09:00 in that cell to make it run at that time

Using more intuitive notation ...with time value in cell D2 in sheet named Data ...

dTime = Sheets("[COLOR=#ff0000]Data[/COLOR]").Range("[COLOR=#ff0000]D2[/COLOR]")

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td] [/td][td] [/td][td] [/td][td] [/td][td] [/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td] [/td][td] [/td][td] [/td][td]

09:00​

[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Data[/td][/tr][/table]