[python-win32] python-win32 Digest, Vol 165, Issue 3

[Doug Sharkey]

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-request at python.org> wrote:

> Send python-win32 mailing list submissions to
>         python-win32 at 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-request at python.org
>
> You can reach the person managing the list at
>         python-win32-owner at 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 <timr at probo.com>
> To: "python-win32 at python.org" <python-win32 at 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.sharkey at 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, timr at probo.com
> Providenza & Boekelheide, Inc.
>
>
> _______________________________________________
> python-win32 mailing list
> python-win32 at python.org
> https://mail.python.org/mailman/listinfo/python-win32
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-win32/attachments/20161204/2051ad31/attachment.html>