Hi all, This bit of code:
objExcel = win32com.client.Dispatch("Excel.Application") objExcel.visible = False objExcel.DisplayAlerts = False objWb=objExcel.Workbooks.Open(filename) is producing this error: File "<COMObject <unknown>>", line 8, in Open com_error: (-2147352567, 'Exception occurred.', (0, u'Microsoft Excel', u"Microsoft Excel cannot access the file '\\\\Win-rfe2cu0ucdn\\EFT_Share\\EFT_ToBeProcessed\\ABCD\\MyFile.P'. There are several possible reasons:\n\n\u2022 The file name or path does not exist.\n\u2022 The file is being used by another program.\n\u2022 The workbook you are trying to save has the same name as a currently open workbook.", u'xlmain11.chm', 0, -2146827284), None) Note: 1. filename is fully qualified (filename=os.path.abspath(...)) 2. The file does exist 3. The file is not being used by another program 4. There is no other open workbook My environment is: - Windows Server 2012 R2, 64bit OS - Python 2.7.12 (v2.7.12:d33e0cf91556, Jun 27 2016, 15:24:40) [MSC v.1500 64 bit (AMD64)] on win32 - pywin32-220.win-amd64-py2.7 - MIcrosoft Excel 2013, 64bit If I run it from my laptop (Windows 8.1 Enterprise, 64bit OS) it works fine. Any help is appreciated. I've been wracking my brain on this for the past 5 days. Thanks, Doug
_______________________________________________ python-win32 mailing list python-win32@python.org https://mail.python.org/mailman/listinfo/python-win32