Help with Macro to import multiple text files.

[Enyavon]

Good afternoon,

I have the following macro which currently works to import text files from a specified folder to a new sheet in the current workbook and also separate it into columns based on CSV etc;

Please Login or Register  to view this content.

I have two questions;

1 - Is it possible to only extract everything in the text file except the first two rows of text, as they are titles which are not needed?

2 - How would I change the macro so that instead of importing it to a new sheet starting at A1, it will import to the current worksheet starting at D3 for example.

I have attached an example text file of the ones I am trying to import.

Many thanks in advance, from a VBA noob.

[JLGWhiz]

This is the code that loads your source file into your consolidated file.

Please Login or Register  to view this content.

It pastes the copied ranges starting at B1, not A1. But, it then deletes column A after all the files are copied, making it appear that it loaded into A1 from the start. If you replace the lines above with the code below it should do what you want.

Please Login or Register  to view this content.

[Enyavon]

Many thanks JLGWhiz!

Now only one problem remains, which is how to only import everything from a text document except the first two lines!

[JLGWhiz]

Many thanks JLGWhiz!

Now only one problem remains, which is how to only import everything from a text document except the first two lines!

Maybe I missed something. I thought the second code I posted did that. It only copies beginning on the third row of the used range. So if data starts on row 1 then the copy range starts from row 3.

If you mean import from the text file to Excel then why not just delete the two rows after you import the data?

[Enyavon]

Main reason is because I used this macro to import 30 odd different text files, each containing alot of lines of data (The example text file is what I import, but that x30), so having to scroll though all of those rows of data once its imported would take way too long and be too tedious. I do have a macro to merge the files if I manually convert the text files to excel files by importing the data, which allows me to set the range that is merged, but I was just wondering if a similar thing is possible with text files, as I essentially dont need the title lines, just the pure data.

[JLGWhiz]

Main reason is because I used this macro to import 30 odd different text files, each containing alot of lines of data (The example text file is what I import, but that x30), so having to scroll though all of those rows of data once its imported would take way too long and be too tedious. I do have a macro to merge the files if I manually convert the text files to excel files by importing the data, which allows me to set the range that is merged, but I was just wondering if a similar thing is possible with text files, as I essentially dont need the title lines, just the pure data.

I wasn't thinking of scrolling though all the files to do it. You can do it with code as you load it to Excel. Modify this line in your Demo macro as shown below.

Please Login or Register  to view this content.

See if that doesn't eliminate the first two rows. Or am I still missing the point somewhere. That is the only code I see that you said extracted data from a text file. If it is a .csv file then it should load into Excel automatically if opened as a workbook. Then you can use vba code just like any other workbook.

[jindon]

Try

Please Login or Register  to view this content.