Importing a Text File Using a Macro

[james_ross]

Hi,

I am new to using excel macros and I am wondering how to go about this.

I need import 4 text files from the same directory. However I need to be able to import the file path into a cell (for example A1), and the file name to be in the macro. I think I have almost done this but I keep getting a run time 1004 error.

Below is what I have so far to import just 1 text file.

Please Login or Register  to view this content.

If someone could help me with this it would be most appreciated.

Thanks.

Moderator's note: Welcome to the forum James. When posting codes they should be enclosed with code tags. Select the code then click the "#" symbol to wrap it with code tags. I'll do it for you now. Thank you!

[Norie]

Assuming FilePath has a valid path and 'TextFile.txt' is a valid filename try this.

Please Login or Register  to view this content.

[patel45]

.....-----------------------------

[james_ross]

Thank you for your reply, however I still get "Run-time error 1004". Do you have any idea what this problem could be? I have checked the filepath and filename and they are both correct.

[Norie]

Whats the actual error message?

[PingPing]

Check that 'FilePath' has a trailing backslash eg. c:\temp\
Are the text files, in fact, Tab Delimited - as you have told the QueryTable they are (".TextFileTabDelimiter = True")?

FWIW, unless you're wedded to QueryTables I'd recommend tackling your problem with ADO instead.

[james_ross]

This is the error message I get.

Run Time Error Message.jpg

[james_ross]

It now works, thank you all for you help.

James