macro to open multiple text files

[ccloak]

I am new to creating macros and would like to open many (100s) space delimited text files into Excel (Mac 2011). The following works for one file (123test.txt) but is there some way to open all .txt files within a specified folder (in this case "MRStexts") so I can do this in batches instead of one at a time? Thanks in advance!

Please Login or Register  to view this content.

‹

[Alf]

First of all a warning the commands I've used works in Excel 2007 and 2003 but as I do have Excel 2011 (Mac) I really don't know if this will work for you.

Please Login or Register  to view this content.

Alf

[arlu1201]

ccloak,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

[ccloak]

Alf, thanks but I get a Run-time error '68': Device unavailable at

Please Login or Register  to view this content.

I think it does not like the *
When I substitute an actual file name for the * it opens that file just fine...
Any suggestions?

[Alf]

I think it does not like the *

Oh dear the "*" was supposed to be the wildcard that should make it possible to loop through all the files with ".txt" ending in sPath folder.

If you can find out what the wildcard character for Excel Mac version is try to substitute "*" with that. Sorry but as I don't use Excel Mac nor know anybody who does so I can't help you any further.

Alf

[Alf]

Found a link at Roin de Bruin with macros and example to dowload for Excel 2011 (Mac). Amost at the bottom of the page there is a description of how to "Loop through files in a folder on a Mac"

http://www.rondebruin.nl/mac.htm#Loop

Alf