Compile multiple .log files into a single .txt file

Hello,

I am looking for VBA code that will allow me to:

1. Compile all of the .log files in a folder into a single .txt file.
2. Import that single .txt file into an Excel sheet.

Currently, I have been using Command Prompt (Windows 7 64-bit) to compile the .log files into a .txt file. Then, I've been manually importing that file into Excel. I was hoping that this could all be done with a single macro.

Please let me know if there is anymore information I can give that will be helpful (this is my first post) and I will get it asap.

Thanks in advance^^

I will give this a shot when I get back this evening.

Originally Posted by JBeaucaire

Then you can simply open the resulting file in Excel.

Does this mean that I cannot use Excel to automatically import the compiled .txt document after it has been created? I was hoping that there could be a single macro that would first compile and then import.

Thanks a bunch for the quick response!

Hi..

I am looking for VBA code that will allow me to:
1. Compile all of the .log files in a folder into a single .txt file.
2. Import that single .txt file into an Excel sheet.

Maybe a slightly different attack can also work..

1. Build array from all .log files.
2. Transpose array to sheet.

Please Login or Register  to view this content.

Originally Posted by JBeaucaire

Yes, you can. It's a single line of code to open a text file in Excel, especially if the filename doesn't change.

Please Login or Register  to view this content.

Add that before the END SUB and the last thing that will happen is the created file will be opened.

This was fabulous! Exactly what I was asking for and you made it very straightforward for me. Thanks a ton!

You're welcome..

If you wanted to test it quickly.. you can just download the attached Workbook in my previous post and just Click the button.. browse to the folder that has the .log files.. and the result will be shown in the Workbook.

Out of interest.. how many lines of data (ball park) are in each of your log files..?

One of the benefits of using code such as:

Please Login or Register  to view this content.

is that it reads ALL of the data from each of your .log files in one go (rather than looping through each line).

Might make a difference if your log files have heaps of rows..

Your code is fantastic, too! It also worked very easily after I selected the proper folder.

As far as lines of data, so far it is not that much. A weekly ballpark figure would be between 1000 and1800 lines, but not more than 3000 . That could change if my research project grows in size, so now I have an added option should I be lucky enough for that to happen.

Thanks very, much for your suggestions and I feel even better about properly (and quickly) preparing my data.