Executing multiple web queries?

[stringer47]

Hi,





I'm using excel for Mac 15.23. I have hundreds of .txt files that are serving as web queries to bring data into excel.





Currently, I'm executing each query individually (Data > Get External Data > Run Saved Query....) then repeating with the next query, and the next one, and the next one....





Obviously, this procedure is relatively time consuming and I'm wondering if there is a way to execute MANY or even ALL of my queries at once instead of doing them individually as described.





Appreciate the help.

 

[mrshl9898]

Here's what I have, though reading your original again I see you use Mac.... So maybe an issue there.

 

[stringer47]

Thanks again.. maybe it's a Mac thing.

For what it's worth, here is what is ticked: