Automating Excel Text File Import from VBA
Posted on 2014-10-21
I have been getting a bunch of data files in .csv format and using Excel to eliminate bad rows and scrub bad cells prior to import. Now I am getting them as .txt files and when I use Excel to open them I lose leading zeroes that I need.
I'm trying to adapt this code from an Excel macro into VBA in Access, but I'm using late binding and Access is blowing up on the code.
Any suggestions on how to "import" in Excel using VBA code would be appreciated.