Daily Save of Table

[alanhather]

Hi I have a small table that gets updated daily from a shared workbook and I was wondering if there is a way to save his data into another excel document on a daily basis and at a specific time and could this also be done with out opening the documents. Currently I open excel and copy the data in to the other document to work on.

May thanks

Alan