Getting External Data from a List of Filenames

[goose]

I have a list of 4 or 5 filenames (without path/extension) in Column A, and I'm trying to Get External Data on from each one in succession. It works fine when I do a separate Get External Data for each one, but because the filenames will be changing each time the macro is run, I need to have it read the names from Column A and import the external data automatically.

Please Login or Register  to view this content.

The path and file format will remain the same each time, but anything I have used to replace the "Connection:=" line has not worked. Any help you can give would be grealty appreciated.

[VBA Noob]

Please read forum rules below and then wrap your code

VBA Noob

[Tarball]

You should be able to make this a variable: This assumes that the path will always be your desktop. It also assumes each file has the same parameters. If not you will need to code for all of this. You should also change the Destination too!

Please Login or Register  to view this content.

[goose]

Please Login or Register  to view this content.

[Tarball]

Umm...Goose. I'd venture a guess that the moderator meant that you should "EDIT" your original post and add code tags rather than having you add a new response with code tags. This does not add value to the thread that you started.