Batch File Processing, Visual Basic for Excel, Visual Basic .NET?
Posted on 2003-03-18
Hello to all the experts out there.
I don't know how "difficult" this question is, so here it goes.
I am trying to write some scripts that will process data. Ideally, I want to be able to batch process groups of files. We have a large collection of data that needs to be processed, and we want a script to automate the process. I am new to VB, but I really like how easy it is to use and code, so I am trying to figure out what the limitations of the software are, and what tools I will need to accomplish the task at hand.
Right now, I am using the VB editor that is included in MS Office, which is obviously a version of VB designed specifically for use with Office (and in my case, MS Excel). SO far, this editor is meeting our needs, but we want to add the ability to batch process files. Basically, we would like to run a script that can search through a folder of our choosing, and search all the *.xls files and process the data as we see fit. This will involve the creation of new data files, reading from source data files (most likely still in the excel format) and processing the source data as well (appending). Is all this possible with the built in VB Editor or should we look into buying the VB package itself so we further utilize the power of this coding language? If we can use the built in editor, any examples of how to open files and batch process them, then close those opened files?
If we need to purchase the full VB package, can we still use it to easily process excel data as we are currently doing with the VB for Applications software that comes with MS Office? Or does the syntax change when you move to VB.net, etc (referencing to specific cells, ranges, performing mathematical computation, etc)?
Thanks for the time and answers!