Excel 2013 importing contents of Text File

Good Morning,

I've spent the last couple of days banging my head against a wall trying to import the contents of a text file via VBA into a bank excel sheet (or VBA array preferably)

I'm trying to use an ADO connection as I have data from other spread sheets importing this way (and so that I can learn something new)

can anyone help me out with this please?

ok this solved it for me - seems fresh eyes help lol.

Please Login or Register  to view this content.