I have given below the activities done in Excel VBA:-

1) I have a Main excel working file where I need to
download the data from various bank statements in a
specified format.

2) The respective bank file will be opened through main
working file by the user and downloads the data in a
specified format on daily basis.

The above mentioned operation was done in EXCEL VBA. As
successfully going on the project for some Target
assessmemnt, we are planning to implement the same with VB6
and Access database.

I would like to know, how can we open a bank statement
(text format & excel format) through VB6 coding and how
can we access from VB6 to text file/excel file to collect
the data.

Could anyone help me at the earliest?

Thanks & Regards
Manikandan Raghavan