How to open Excel files and click a button ?

Hi guys,

I have been looking for a solution for hours but no success

Here is my problem. I have 5 Excel sheets. Each Excel sheet contains a button and a lot of (similar) vba code linked to the button. When someone clicks on the button the vba code is executed. Each button has to be clicked once per day so I was looking for a way to automate this and process all the data during the night.

I have been experimenting with Auto_Open and Workbook_Open but no success. I created an Excel sheet called start.xls which will trigger 'the clicks on the buttons' via Workbook_Open ... but how do I let vba click the button ? I even tried to record a macro via the wizard but the click on the button is not recorded

I hope someone can help me
Bananas (again)