Hello,

I want to update an excel 2007 file automatically in batch mode.

I have a trigger point outside of excel. Each time an event happen, I want
to run a bat file or a VBS to call excel to open my excel file and update it,
save it and end.

The steps that I want to automat a
1. How to Open my excel file in batch mode (hide)
2. Call a micro automatically
3. Save my excel file
4. End excel

I want to do this without any user interaction.

My Company has a process that runs all day with new data. Each time this
happen we want to update this excel file.

Any Help. Thanks.