I suspect you don't understand that dates are store as a number representing
the number of days from a base date (Usually 31 dec 1899).

? CDBL(now)
38569.4854050926

? format(38569.4854050926,"mmm dd, yyyy hh:mm")
Aug 05, 2005 11:38

so I suspect you are getting the correct data, but now just need to
interpret it correctly.

--
Regards,
Tom Ogilvy

"Pat" wrote in message
...
Hi All,

I built a macro to get data from excel workbooks without open it. So what
i
do is use the function ExecuteExcel4Macro to get the value from couple of
cell in the excel workbook. Til now it work very well. And is few faster
than first open the excel book and then get the value.

But now i got the following problem, when i try to use this funcyion
'ExecuteExcel4Macro' to get data from some cells this has another
cell-format. Its doesn't work any more. Normally i just try to get data
from
a cell with 'General' format. And i when try to get value from cell with
'Date-format' of another format, it didn't seems to work any more.

Can someone help me to solve this problem? or does anyone get a
sugguestion?
other methode?

Best regards,

Patrick.