VBA to copy multiples txt file saved in the same folder

[alexxgalaxy]

I searched from the net and found below code that can copy multiple files saved in the same folder. I tried to use it to copy some txt files and came across with some problem. Please see below the example of one these txt files.

Invoice Voucher Transaction Text Due Amount Currency
H-00001 ICINV-00001 400000045R1 4/21/12 3,390

If I manually copied and paste the data to an excel spreadsheet, the data will go to separate column as follows.

Column 1, Column 2, Column 3, Column 4, Column 5
Invoice, Voucher, Transaction Text, Due, Amount Currency
H-00001, ICINV-00001, 400000045 R1, 4/21/12, 3,390


But if copying with the following code, the data pasted on the excel spreadsheet will become the following.

Column 1
InvoiceVoucherTransactionTextDueAmountCurrency
H-00001ICINV-00001400000045R14/21/123,390

Can anyone advise how to amend the code below so that the data pasted on the spreadsheet can appear as those copied and pasted manually to the spreadsheet?

Please Login or Register  to view this content.

[alexxgalaxy]

Can anyone give me a hand?