import external data
I'm trying to set up some web queries. I have about 1000+ entries that I'm trying to get info for. they are all codes in the form of "XXXXX" where the X's are letters and numbers. I have a list of them and can manipulate them as needed. Each entry has a corresponding webpage in the form of www.website.com/entry="XXXXX" where XXXXX is the entry I'm looking up. Each webpage has the same format with the same tables.
Is there a way I can use "import external data" so that the cell value is inserted in to the link? Or do I have to set up a web query for each one individually?
Are you looking at doing this via a macro?
Please Read Forum Rules
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post
Top Excel links
for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
I'd prefer not to. just wondering if there was something I was missing.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1