Close

February 2, 2015

More Excel VBA coding

I’ve given the toolkit a bit of a back seat in the last couple of weeks.  The most I’ve done to it is open it up and borrow some generic code from it for the work I’ve been doing towards an Excel spreadsheet.

The spreadsheet is just a time-saver for another department which allows the bulk import, filtering, fixing and then export of various text files.  Some contain over 56000 lines of plain text which needed to be examined for errors and then saved back out.  What used to take hours of staring at Excel .. now takes less than a few minutes.

A pat on the back for me and more knowledge added to my VBA bow as it’s been a good few years since I last coded any VBA relating to filtering files in and out via Excel.

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: