excel find last column

[Lance Hoffmeyer]

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







Luap777 at gmail.com 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
> 
>