I am new to excel VBA programming and need help.

I need help with writing a script to automatically update an excel sheet from a Sharepoint list. This script will run at certain intervals and automaticaly update the excel sheet. Once the excel sheet is updated, it will save the sheet in a comma (or tab) delimited text format. ALL this will happen in the background without opening excel.

We are using excel 2010.

Thank you, in advance, for all your help. It is greatly appreciated.