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

[Rolex]

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 are:
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.

 

[Joel]

There are two methods

1) You can run excel from a batch command line and specify the file to open.
This will not meet all your requirements because excel will be visible.

2) Modify the Excel file without opening the file. Do a search at this
discussion group for :

read excel file without opening

The are a few postings that are revelant.