Search results for query: *

Skip, I combined the two macros to create the following solution that works. Thanks, Bill Option Explicit Sub Text_file_convert() Dim Filter As String, Title As String, msg As String Dim i As Integer, FilterIndex As Integer Dim FileName As Variant Dim Path As String...

Skip, You have good insights and questions. My code opens 100 workbooks, which I do not want to do. You are correct that I want to insert the contents of multiple text files into successive columns of a single worksheet. I answered your three questions below. Do you want to inport all the text...

Skip, I am sorry but I didn't understand what you were asking for because I was focused on the macro I pasted in my original post to this thread that is embedded in the Excel spreadsheet that I didn't create using the record macro function. This current posting includes a macro I created using...

I need to import text from several text files into successive columns in a single XLS worksheet. Thread707-1444974 of this forum provided a solution for opening many text files and saving them in separate xls Workbook files. I modified that code below to enable it to use part of the file path as...

These solutions are well done. I have a slightly different problem that could be solved by a slight modification of HughLerwill's code, but I have been unable to figure out how to make the modification work. I would like to place the imported text from each .txt file into successive columns in...