1. Open a File
2. Read an input line
3. Process the input line
4. Write the processed input line to an output file.
Sounds easy enough. But processing the input line will require some straightforward text manipulation. Sounds easy enough.
My problem is: I'll be working with some medium size text files ranging in size from 30MB to 450MB. I expect that with the larger input files, this app will take some time to complete. (Depending on computer speed/RAM).
My other problem is: The target machine that this will be running on is a
1.4G w/ 256 MB.
Is there any suggestions or tricks that I can use to process the larger files (which I may add will be done on a daily basis) besides the SplitFile function?
In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function. While writing that article I realized that no o…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…