[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.