MS Excel Multiple Files into Spreadsheet

I am wanting to import multiple txt files into a spreadsheet and am trying to write a macro in VBA for this. I have it all working except for the problem that each new file is inserted horizontally instead of vertically below the previous file. This is a problem because all of the files are the exact same format and need the columns to line up. How can I enter a new line in the code so the next file gets put onto a new line below the last file?

Here is my code:

Please Login or Register  to view this content.

Any help is much appreciated thank you!!!

Hi Jay and welcome to the forum,

Your code is too hard to read unless you put it in code tabs.

Edit your origianl post (click the green button under your message)
Then click on Go Advanced below the message area.
Select the text that is code and click on the # icon above the message area
Then click Save.

We might be able to help buy you can make it easier. Also read the rules and you might even attach a sample file so we can see what your data is with the code.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Hi jaym911

It looks to me like it is your

Please Login or Register  to view this content.

You need to calculate where the last row of data is in your accumulation sheet and make that the destination you are going to copy the new data to.

You need to create a variable and use it to find the last row of data like:

Please Login or Register  to view this content.

Then I believe you need to set your

Please Login or Register  to view this content.

I hope that helps.