Re: [python-win32] Excel / Word: setting properties

tps://siemens.com/ingenuityforlife> Von: python-win32 [mailto:python-win32-bounces+hartmut.niemann=siemens@python.org] Im Auftrag von Tim Roberts Gesendet: Freitag, 2. März 2018 09:13 An: Python-Win32 List Betreff: Re: [python-win32] Excel / Word: setting properties On Mar 2, 2018, at 12:07 AM, N

Re: [python-win32] Excel / Word: setting properties

018 18:20 An: Python-Win32 List Betreff: Re: [python-win32] Excel / Word: setting properties Niemann, Hartmut wrote: > >   > > How do I set the [Excel workbook] standard property "Keywords" to > "C_Restricted" and the user property "Document Confidentiality&

[python-win32] Excel / Word: setting properties

Hi! I create an excel document using the COM interface. Now I need to set two properties to be compatible with a new company rule: "[the tool] uses MS Office standard ('Keyword') and custom ('Document Confidentiality') properties. so if your code is able to preset values to these properties

[python-win32] pywin32 und pypiwin32: what is the difference?

Hello! When looking at an upgrade of pyinstaller, I came across this sentence: "ForWindows, PyWin32 or the more recent pypiwin32, is a prerequisite" What is the difference between these two? I find pypiwin at https://pypi.python.org/pypi/pypiwin32 where I find build 219 dating around New year

[python-win32] Opening Access (mdb) database: ADODB.Connection - Der Provider kann nicht gefunden werden

Hello! I try to open and write an (Access 2000) mdb file, and get an error I cannot interpret. This code as worked in the past (two months ago) and works without modification on a different PC of a colleague, so chances are my configuration misses a simple thing, a software package (update)

Re: [python-win32] Excel Characters object

Tim Roberts wrote: Niemann, Hartmut wrote:   I want to create an Excel file through the python COM interface. I can open the file, fill the cells, save the file.   Now I want to color single characters in the cell content.   In VBA ( see http://stackoverflow.com/questions/7618121/excel-vba-change

[python-win32] Excel Characters object

Hello! I want to create an Excel file through the python COM interface. I can open the file, fill the cells, save the file. Now I want to color single characters in the cell content. In VBA ( see http://stackoverflow.com/questions/7618121/excel-vba-change-color-of-certain-characters-in-a-cell)

[python-win32] Excel + pyinstaller: missing a constant: xlTopToBottom

Hello! The following snippet from win32com.client import constants as xl_constants wbook.ActiveSheet.Range('A3:N' + str(row + 1)).Sort( Key1 = wbook.ActiveSheet.Range('B3'), Orientation = xl_constants.xlTopToBottom, DataOption1 = xl_constants.xlSortTextAsNumbers

[python-win32] Makepy for Access on Win7

Hello! I had to switch from Windows XP to Windows 7 and redo my python installation there. I need to generate COM modules for Microsoft products I use. When running makepy on Windows 7 / Python 2.7.3 (64bit) / pywin32-218.win-amd64-py2.7.exe for Microsoft Access 12, I get: Generating to

Re: [python-win32] ValueError in relpath

Niemann, Hartmut wrote: No, the relative path that crashed it has 245 characters: 2012-08-07_diffzu_2012-09-12\PRJ\I1SITRAC\wrk\130_Eclipse\Work space\.metadata\.plugins\com.python.pydev.analysis\python_v1 _eo3pb4rfuku7u65tfbbltnbp5\v1_indexcache\pylint.test.input.fun

Re: [python-win32] ValueError in relpath

Hello Tim! Thank you for your reply. -Ursprüngliche Nachricht- Niemann, Hartmut wrote: I am not subscribed to this mailing list (so CC me on all replies please), How did you send this? The list only accepts postings from members. I did nothing special, it obviously accepted

[python-win32] ValueError in relpath

Hello! I am not subscribed to this mailing list (so CC me on all replies please), but I encountered something that looks like a Windows related bug to me and hope that somebody knows how to take care of it in the python way. I have a tool that traverses and compares large file trees.