naxchamp.blogg.se

Then, I copied his ImportFixedWidth code into another module (Module2, see code block at the end of this post).

First, I copied his example macro calling the ImportFixedWidth function and edited it to reflect the number and length of each of my data fields. I found Chip Pearson's ImportFixedWidth function and have been trying to implement it per his description. Issue: As I'm new to VBA, I looked for existing code. The text files all have the same fields and format. I would really appreciate any help!Ĭontext: I am trying to import a batch of fixed-width text files into separate Excel workbooks.

I am new to VBA and hoping for some help implementing a user-defined function.