Tocogroup
asked on
What sort of application should I build to process data files ?
Hi All,
I'm in the process of building a VBA application which will take a number of data files from different sources (.csv, .txt, Access database) and consolidate them into a single Excel worksheet. I will want to do some basic validation on each input file, depending on its source, prior to copying the data to a worksheet.
Where would you start with this ? How should I execute the VBA procedures ? From an Excel workbook itself ? If so, would you suggest a User Form interface, or a worksheet, or an event ? Or is there another way of running a VBA application ?
I'm open to ideas but my programming knowledge is limited to Excel VBA.
Regards
Toco
I'm in the process of building a VBA application which will take a number of data files from different sources (.csv, .txt, Access database) and consolidate them into a single Excel worksheet. I will want to do some basic validation on each input file, depending on its source, prior to copying the data to a worksheet.
Where would you start with this ? How should I execute the VBA procedures ? From an Excel workbook itself ? If so, would you suggest a User Form interface, or a worksheet, or an event ? Or is there another way of running a VBA application ?
I'm open to ideas but my programming knowledge is limited to Excel VBA.
Regards
Toco
1. you can pull data into a workbook
2. you can push data into a workbook
3. you can use VBA or VBScript to 'package' your coode
4. you can do basic file I/O or use ADO to treat the data sources as tables
I think that some of our recommendations might depend on what kind of validation you need to perform.
2. you can push data into a workbook
3. you can use VBA or VBScript to 'package' your coode
4. you can do basic file I/O or use ADO to treat the data sources as tables
I think that some of our recommendations might depend on what kind of validation you need to perform.
ASKER
Thanks Steve for your advice. It may be the most practical solution for me.
Aikimark, can you explain Pull and Push a little more please ? How would I 'package' my code ? What do you mean by 'basic file I/O ?
Aikimark, can you explain Pull and Push a little more please ? How would I 'package' my code ? What do you mean by 'basic file I/O ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your help.
It's given me something to think about and research further into.
And yes I shall revisit this site when I have scoped the project.
Regards
Toco
It's given me something to think about and research further into.
And yes I shall revisit this site when I have scoped the project.
Regards
Toco
If your knowledge is limited to just excel VBA then that should be the application to use.
It is more than capable of what you need, so why go to the trouble of using something else.
Start with an excel workbook and use it to open the files.
A user form is likely not necessary.
It all depends on the tasks required.