conversion

venkat · Power User Joined: 11 Nov 2003 Posts: 64

Dear All,

i have written macro which will pick up values from the cells.
If i say "oCell.String", it returns string value - no issues
"oCell.Value", it returns numeric value - no issues
but if i want the date then
what i have done is
i declared a variable of date format, then assigning the cell value, it works some times also it fails saying that "Data type mismatch"
ie
dim varDate as Date
varDate = oCell.String

My query is how to get the date value directly from the cell.

Regards
Venkat

SergeM · Posted: Tue Jan 27, 2004 9:04 am Post subject:

I think it's :
dim varDate as Date
varDate = oCell.value 'instead varDate = oCell.value
print(CStr(varDate))

seems to work for me.
_________________
Linux & Windows OOo3.0
UNO & C++ : WIKI
http://wiki.services.openoffice.org/wiki/Using_Cpp_with_the_OOo_SDK
In French
http://wiki.services.openoffice.org/wiki/Documentation/FR/Cpp_Guide

SergeM · Posted: Tue Jan 27, 2004 9:13 am Post subject:

i have done a fault in the previous post (in the comment)
try :