View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
K.K.[_2_] K.K.[_2_] is offline
external usenet poster
 
Posts: 8
Default How to copy entire row fm an xls file to another xls file?

Hi All,

I have an app in VB6 that will open an excel file, validate then process the
data, if the validation is failed for a record, I want to
copy (append) that record (entire row) from the original data worksheet to
an exisiting xls file ?

I think I prbably can use ADO connection to get the record but Do you think
using an ADO connection would Not be better?
Or there is another way to do it?

Thanks a lot!

K.K.