Sorry, forgot to mention Subject in my earlier post, hence reposting.
------------
I am writing a script which need's to convert an excel file to csv (text) format. For that I am using the following code:
excel = win32com.client .Dispatch("Exce l.Application", "Quit")
workbook = excel.Workbooks .Open(xlsfile)
workbook.SaveAs (csvfile, FileFormat=24) # 24 represents xlCSVMSDOS
workbook.Close( False)
excel.Quit()
I did not have any problem running this script on a windows xp machine with python 2.5.2 and windows extensions. But I get the following error when I run the same script on a windows 2003 server with the same python and windows extension installation:
excel = win32com.client .Dispatch("Exce l.Application", "Quit")
File "D:\Python25\Li b\site-packages\win32c om\client\__ini t__.py", line 95, in Dispatch
dispatch, userName = dynamic._GetGoo dDispatchAndUse rName(dispatch, userName,clsctx )
File "D:\Python25\li b\site-packages\win32c om\client\dynam ic.py", line 98, in _GetGoodDispatc hAndUserName
return (_GetGoodDispat ch(IDispatch, clsctx), userName)
File "D:\Python25\li b\site-packages\win32c om\client\dynam ic.py", line 78, in _GetGoodDispatc h
IDispatch = pythoncom.CoCre ateInstance(IDi spatch, None, clsctx, pythoncom.IID_I Dispatch)
com_error: (-2147221005, 'Invalid class string', None, None)
I verified that installation is same. Any idea's as to what might be the problem? One thing I have noticed though is I can't see Microsoft office 11.0 object library when I do combrowse on windows 2003 server. I also to tried to reinstall python and windows extension. But still no luck.
I would appreciate if anyone can guide me as to why this is happening and how to resolve this.
Thanks,
SPJ
_______________ _______________ _______________ _______________ _______________ _________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i...Dypao8Wcj9tAcJ