VBA code to import .txt file and separate in columns

[Joshua27]

Hi Everyone,

I'm sort of new to VBA and am looking for a code that would enable to me press a command button, select a txt file that is not tab delimited, and to insert in the coding where to separate in columns using the number of characters. Is this something regular you guys can help with?

Many Thanks!

Joshua

[Joshua27]

Sorry I forgot to mention, the txt file would have to be imported on a different sheet. Thanks! My Excel version is 2010 if this matters.

[rmrjr22]

Here you go. This code should send you on your way. The credit goes to sitestory.dk. I came across this on my travels to import .csv format file.
There are explanations here and there to help you understand what you are dealing with.

Hope this helps!

Please Login or Register  to view this content.

[Joshua27]

Thanks, that worked perfectly with a bit of tweaking! +Reps