Hello,

Does anyone know how to open and save the excel file without the full
version of excel installed?

Our requirement is, the VBScript code in the DTS package task should
change the sheet name of the excel file to "Sheet1". We do not want to
install full version of Excel in the server just to do this task. I am
hoping that few DLL's from the Excel DLL's list should be able to the
job. I need list of those DLL's.

I do not have the list of dlls needed (Should be on Google) but remember
MS do not recommend Office in an unattended environmnet so this may be
an issue if scheduling. You can use CREATE TABLE on the Excel
Connection to create new worksheets/Named Ranges/Tables.

Will that not do what you want?

Allan

"Yunus's Group" <yunusasmath (AT) gmail (DOT) com> wrote

Actually we get the excel file with the sheet name which is different
from what it needs to be. So, I thought of putting the task of changing
the sheet name part of the DTS process. I can write the code in ActiveX
script task in the DTS package to do this. But the problem is that we
need to install Excel in the server. I was wondering if I can get the
job done just by copying the few DLL's, I do not have to install the
excel on the server just to take care of this small issue. By the way
we have the corporate wide licence for the excel. I just need help in
choosing the right DLL's.