S
steve.luo1
Hello,
I want to automatically update an excel file in batch mode.
since my excel file have an add-in and lot of cells need to be updated
by the add-in functions.
I set auto calculation in workbook's open event and remove the fomular
after update is done.
The steps that I am doing now is
1. Open my excel file using C# DDE (interop)
2. Call a micro to remove the formula
3. Save my excel file
4. quit excel
And the problem is that if there are just about 10 Cells need to call
add-in function, the above steps work fine. However, when the number
of cells is big, for example 500, all the cells have '#Name?'.
it seems that there is no enought time to allow add-in function to
finish.
so what should I do?
Any Help. Thanks.
I want to automatically update an excel file in batch mode.
since my excel file have an add-in and lot of cells need to be updated
by the add-in functions.
I set auto calculation in workbook's open event and remove the fomular
after update is done.
The steps that I am doing now is
1. Open my excel file using C# DDE (interop)
2. Call a micro to remove the formula
3. Save my excel file
4. quit excel
And the problem is that if there are just about 10 Cells need to call
add-in function, the above steps work fine. However, when the number
of cells is big, for example 500, all the cells have '#Name?'.
it seems that there is no enought time to allow add-in function to
finish.
so what should I do?
Any Help. Thanks.