Forum Discussion
Solved
Excel queries from the web
Hi,
First of I'm new to this community so hello and I'm using excel 2016!
But I've a quick question regarding Excel queries from the web, or Data> New queries > From other sources > From Web.
Its working as intended, but I've got a list of over 120 links that I want to import into a excel file. How does one go and do that automated? Without having to do it all manually.
Kind regards,
Andy
What you are asking is possible using VBA. There is a code in this link that shows how you can use VBA to add queries. If you have some basic knowledge of VBA then you can set up your links into a Table and then the VBA to be modified by adding for each loop to run on each of the links that are placed in the cells. So, again there are lots of unanswered questions here, how links data looks like, what part of the data to be fetched and included and what data from web to be excluded.
so, I am not sure how badly you want this automation. I am not sure if someone here will do the whole project for you, you probably need to hire a professional VBA developer to do this for you and I guess adding 120 links manually will probably outweigh the hustle of creating automation for this.
5 Replies
What you are asking is possible using VBA. There is a code in this link that shows how you can use VBA to add queries. If you have some basic knowledge of VBA then you can set up your links into a Table and then the VBA to be modified by adding for each loop to run on each of the links that are placed in the cells. So, again there are lots of unanswered questions here, how links data looks like, what part of the data to be fetched and included and what data from web to be excluded.
so, I am not sure how badly you want this automation. I am not sure if someone here will do the whole project for you, you probably need to hire a professional VBA developer to do this for you and I guess adding 120 links manually will probably outweigh the hustle of creating automation for this.
Excuse me for the late reply, First thanks for the reply, will surely look in to it. And for now it is 120 links. But I'm certain it will grow.
I think the link will help me a long way again thanks for your help!Kind regards,
andy
Andy,
have you tried a web search on the subject?
- Hi detlef,
Yes I have I couldn't find what I was looking for thats why I've tried asking here.Well, then I can't help you any further since you tried all the 4 million results I get with a web search.
