I ran makepy.py and loaded Microsoft Excel Object Library 11.0
I have imported:
import win32com.client
from win32com.client import constants
import re
import codecs,win32com.client
import time
import datetime
import win32com.client.dynamic
using this expression
lastcol = sh.UsedRange.Find("*", "A1",
win32com.client.constant.SearchOrder=xlByColumns,
win32com.client.constants.SearchDirection=xlPrevious).Column
I get error:
, line 245
lastcol = sh.UsedRange.Find("*", "A1",
win32com.client.constant.SearchOrder=xlByColumns,
win32com.client.constants.SearchDirection=xlPrevious).Column
SyntaxError: keyword can't be an expression
Tool completed with exit code 1
Guess I am getting closer to the solution? LOL
Sorry for being ignorant but I am a newbie and I don't understand all this
python/excel stuff.
Lance
[EMAIL PROTECTED] wrote:
>> I get the error that xlPrevious is not defined.
>>
>
> If you are using pythonwin, run the COM Makepy utility on Microsoft
> Excel Object Library. Then you have access to the defined constants as
> follows.
>
>>>> import win32com.client
>>>> win32com.client.constants.xlPrevious
> 2
>
> Hope this helps.
>
> Paul
>
>
--
http://mail.python.org/mailman/listinfo/python-list
