[python-win32] Standard Excel add-in does not load?

[Jimmy Retzlaff]

Blair Hall [mailto:b.hall@irl.cri.nz] wrote:
...
>import win32com.client
>import pythoncom
>x =3D win32com.client.Dispatch('Excel.Application')
>x.Visible =3D 1
>wb =3D x.WorkBooks.Add()
>x.Cells.Item(1,1).Formula =3D '=3DCOMPLEX(1,2)'
>x.Quit()
>x =3D None
...
>To summarize: it appears that the standard add-in 'Analysis Toolpak'
>is not loaded correctly when Excel is activated by the script above.
...

This knowledge base article demonstrates how to do it from VB:
http://support.microsoft.com/default.aspx?scid=3DKB;en-us;q270844

I would imagine the same technique would work from Python. These
articles talk more about the issue:
http://support.microsoft.com/default.aspx?scid=3DKB;en-us;q108888
http://support.microsoft.com/default.aspx?scid=3DKB;en-us;q213489

Jimmy