Hi Tim Appreciate the response. Although it has a .P extension it's actually an Excel spreadsheet (xlsx format). Business rules require the name format. I could rename it but I suspect the name isn't the issue since this code works fine on my 2008 laptop with the .P file. I'll try renaming it just to be sure.
Thanks Doug On Dec 4, 2016 12:00 PM, <[email protected]> wrote: > Send python-win32 mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > https://mail.python.org/mailman/listinfo/python-win32 > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of python-win32 digest..." > > Today's Topics: > > 1. Re: Help with com_error: (-2147352567, 'Exception occurred.', > (0, u'Microsoft Excel', u"Microsoft Excel cannot access the file > (Tim Roberts) > > > ---------- Forwarded message ---------- > From: Tim Roberts <[email protected]> > To: "[email protected]" <[email protected]> > Cc: > Date: Sun, 4 Dec 2016 00:37:45 -0800 > Subject: Re: [python-win32] Help with com_error: (-2147352567, 'Exception > occurred.', (0, u'Microsoft Excel', u"Microsoft Excel cannot access the file > On Dec 2, 2016, at 1:56 PM, Doug Sharkey <[email protected]> > wrote: > > > > 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'. > > What do you expect Excel to do with a file with the extension .P? > — > Tim Roberts, [email protected] > Providenza & Boekelheide, Inc. > > > _______________________________________________ > python-win32 mailing list > [email protected] > https://mail.python.org/mailman/listinfo/python-win32 > >
_______________________________________________ python-win32 mailing list [email protected] https://mail.python.org/mailman/listinfo/python-win32
