You should be able to use the Win32::OLE::Variant module to extract the date.
Do a 'perldoc Win32::OLE::Variant' and check out the Date() method. -----Original Message----- From: Tim [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 2:13 PM To: [email protected] Subject: Win32::OLE question(s) Hello. The following code produces the output below. The first column should be a date. This happens whether the "valof" function is used or not. Anyone have any Variant tricks? <snip> SHEET: Inventory Order By Qty Win32::OLE::Variant=SCALAR(0x1a0d108) 400 Win32::OLE::Variant=SCALAR(0x1a10310) 84 Win32::OLE::Variant=SCALAR(0x1a102f8) 100 Win32::OLE::Variant=SCALAR(0x1a102e0) 196 Win32::OLE::Variant=SCALAR(0x1a0d108) 100 Win32::OLE::Variant=SCALAR(0x1a10310) 1 Win32::OLE::Variant=SCALAR(0x1a102f8) 100 Win32::OLE::Variant=SCALAR(0x1a102e0) 200 -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
