how can i automatically update a spreadsheet once each day..i have a macro “accumulator” that i want to run once a day at 6pm ..i have tried this below:
Sub SetRunTime()
Application.OnTime TimeValue (“12:00:00pm”), “Accumulator”
End Sub
Sub Accumulator()
Worksheets(3).Range(“f1:f1000”).Copy
Worksheets(3).Range(“g1:g1000”).PasteSpecial Paste:=xlValues, Operation:=xlAdd
End Sub
but it will not work, i leave the spreadsheet open but it still don’t update…i can update manually, but i need it to update automatically and preferably only once a day as a security in case someone tries to run again the same day manually…any suggestions?
