Loading Excel addins in a progress routine

[HenryW]

I am using Progress to load a template and load data from a Progress database. Since adding a service pack to Excel 2003, the addins that were loaded as default before no longer are activate when I start the program.

It looks like I need to load and activate specific addins now to have the program work again.

I have idetified the addins and where the library is (in case the user is using Excel 2000).

DEFINE VAR cLibraryPath AS CHARACTER.
DEFINE VAR cAnalysisPack AS CHARACTER INITIAL 'Analysis\ANALYS32.XLL'.
DEFINE VAR cAnalysisPackVBA AS CHARACTER INITIAL 'Analysis\ATPVBAEN.XLA'.
DEFINE VAR cConditionalSum AS CHARACTER INITIAL 'SUMIF.XLA'.
DEFINE VAR cSolver AS CHARACTER INITIAL 'Solver\SOLVER.XLA'.
cLibraryPath = chExcelApp:LibraryPath + '\'.
cAnalysisPack = cLibraryPath + cAnalysisPack.
cAnalysisPackVBA = cLibraryPath + cAnalysisPackVBA.
cConditionalSum = cLibraryPath + cConditionalSum.
cSolver = cLibraryPath + cSolver.

chWorkbook = chExcelApp:Workbooks:OPEN(cAnalysisPack).
chWorkbook = chExcelApp:Workbooks:OPEN(cAnalysisPackVBA).
chWorkbook = chExcelApp:Workbooks:OPEN(cConditionalSum).
chWorkbook = chExcelApp:Workbooks:OPEN(cSolver).

Unfortunately the above code does not do it.

Can anyone please show me the solution?

Thanks