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.