Thanks to JR2003 I have got a program that splits text files into splits of 1000. Now I need to take each of those splits and merge them together - so for example instead of the file being:
etc upto 1000
it will be
sometimes the file won't have 10000 rercords in becasue there may have been some records left over at the end of the splits, so the last file may only have a few hundred records in it.
below is the code JR2003 gave me for splitting the files, I would prefer to have the merging part seperate if possible. Can anyone get me started? don't really have much of an idea how to go about this.
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
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…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.