how to execute multiple web queries?

stringer47

New member
Joined
Feb 26, 2020
Messages
1
Reaction score
0
Points
0
Excel Version(s)
Mac 2016
Hi,



I'm using excel for Mac 2016 . 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.
 
Back
Top