MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Data collection from Excel file through VB-6

  Asked By: Aloisa    Date: Dec 18    Category: MS Office    Views: 917

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 through VB6 coding
to collect the data.

Could anyone help me at the earliest?



1 Answer Found

Answer #1    Answered By: Ivan Coleman     Answered On: Dec 18

There are a lot of simularities with VB6.
Have you tried just running the VBA code as is and seeing what errors crop
up and correcting them?

I have no idea if that will work at all but it's what I would try first.

Also, If it works in VBA why go to VB?

Didn't find what you were looking for? Find more on Data collection from Excel file through VB-6 Or get search suggestion and latest updates.