I need to be able to import a delimited text file into an Excel spreadsheet, but I want to do it through code.
It's easy enough to do through Excel, but I want to be able to automate it through VB6 code.
I can use OLE as it it's only going to be run on my PC, and I have Excel installed.
Sample code will be really appreciated!
Hope someone can help...