Yes Ron...the destination workbook is xlsb ang the source workbook is xls.
Can it still be working even though different type?

The other one Ron, my problem now in this vlookup formula in the source date
column it the date is nothing/blank, but in the destination workbook it shows
" 0-Jan-00".

How can I make it to be the same...(looked blank), the date "0-Jan-00"
doesnot mean anything, and I am affraid if I make the formula sum if
zerro,......it will effect the result)

Thanks for your help.


--
H. Frank Situmorang


"Ron Rosenfeld" wrote:

On Thu, 17 Jul 2008 19:04:01 -0700, Frank Situmorang
wrote:

Thanks to all of you, Ron and Jarek. In fact the problem is that the source
sheet and the destination sheet are different, one in binary and one in
nomral excel.

Thanks very much
--
H. Frank Situmorang

Do you mean that one is an xlsb file and the other not? Or is the binary file
not an Excel file at all?

If the "binary" file is an xlsb file, I would not have expected that to make a
difference. Can you provide a little more information? I'd like to try to
reproduce that issue here.
--ron