I have a spreadsheet that brings in data from another source.

The spreadsheet has a button that you press and it updates the data.The code
is under 'Micrososft Excel Objects' Sheet 1
Private Sub CommandButton2_Click()

Then on another Sheet I wrote a module called "calculations" that sorts
trough the data and does some calculations.

This takes a very long time to update so i want to set it up so that it
autoupdates at midnight everynight. so first it will update the spreadsheet
that brings in the info from another source then it will do the calculations
from my module.