Is there a way to iimport a file and format it text to columns with VBA?
Is there a way to iimport a file and format it text to columns with VBA?
Hi Austen.
Absolutely! Try recording a macro to do just that. It's probably the easiest way to do it, as the import uses some pretty funky Array methods for each column. Not too hard to work with once you get used to it, but it can be pretty intimidating the first time.
I still start by recording the import, and then tweaking it from there.
HTH,
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!