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, <python-win32-requ...@python.org> wrote: > Send python-win32 mailing list submissions to > python-win32@python.org > > 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 > python-win32-requ...@python.org > > You can reach the person managing the list at > python-win32-ow...@python.org > > 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 <t...@probo.com> > To: "python-win32@python.org" <python-win32@python.org> > 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 <douglas.shar...@gmail.com> > 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, t...@probo.com > Providenza & Boekelheide, Inc. > > > _______________________________________________ > python-win32 mailing list > python-win32@python.org > https://mail.python.org/mailman/listinfo/python-win32 > >
_______________________________________________ python-win32 mailing list python-win32@python.org https://mail.python.org/mailman/listinfo/python-win32
