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

On Dec 4, 2016, at 9:17 AM, Doug Sharkey wrote: > > Appreciate the response. Although it has a .P extension it's actually an > Excel spreadsheet (xlsx format). Business rules require the name format. How does that make any sense at all? If you double-click on that file name, the system isn't

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

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

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 wrote: > > Hi all, > > This bit of code: > >objExcel = win32com.client.Dispatch("Excel.Application") > objExcel.visible = False > objExcel.DisplayAlerts = False > objWb=objExcel.Workbooks.Open(fil