EXCEL with external data connections

Hello, 

I need help.
I nedd to update excel book with external data connections, automatically. 

How can I do that? 

I need to automattically open the excel book, update data connections and data in the book, and after that close the book. 

How can I do that automatically?

Can you help please?

Thnks.