Import multiple .txt files to multiple sheet

[hcyeap]

Hi all,

I need to create a dynamic template for importing data from multiple .txt files to my workbook on a daily basis.

I recorded the macro for importing ONE txt files and starting to deveop it into looping through multiple txt files and sheets but to no avail.

1) Currently I have 4 named ranges
FileLocation = Location of my source file
FileName = All the file names of my txt files
SheetDestination = The sheet to be paste for each txt file (further explaination below)
FileFormat = .txt (for VBA purpose)

2) The macro recorded was in "ActiveSheet", thus I thought of looping through each sheet (put the activate code at the first line) for the codes to run.

3) ColA ColB
1 SP.txt
2 IND.txt
3 US.txt
4
5
6
Column A is my SheetDestination, while Column B is the respective filename for source txt file. My final intended result would be simply macthing sheet 1 against SP, sheet 2 against IND, sheet 3 against US... so on and so forth....

Attached is my sample file, with the codes I tried so far....

Appreciate if anyone could assist. I would provide further details for any unclear areas.

Thank you!

[hcyeap]

self bump!

[snb]

I second that bump just to illustrate how little patience this OP has.

[Tinbendr]

Please Login or Register  to view this content.

[hcyeap]

Hi Tinbendr,

Thank you for your kind assistance.
Very much appreciated.

Regards.