[Tutor] Date in Excel (Win32Com)
Terje Johan Abrahamsen
terjeja@hotmail.com
Thu, 30 May 2002 19:39:17 +0000
I use Win32Com to move info from Excel to an AS/400 system. I need to check
that the dates corespond in the two systems. In AS/400 I would use this to
pick up the value:
ex = accountcurrents.ex.ActiveSession.Screen.GetString(14, 15, 8)
then if I type:
>>>ex
I get:
u'10/30/00'
However, when I do the same in Excel:
xl = accountcurrents.xlSheet.Cells(9,2).Value
And type:
>>>xl
I get:
<time object at 0x012196C0>
How can I get a string that I can compare to the ex value, so I can check if
the dates are the same?
Thanks in advance,
Terje
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.