Web query url based on data in cell
I am trying to make Excel to the grunt work! Here's the problem and how I'm
trying to tackle it.
Problem: I need a list of usernames in a web-based database, and I have
unique user id numbers. I have the url string needed to conduct the search,
and what I need excel to do is this:
Take the user id number from cell I2 (I3, etc for over 2000 records) and
paste that onto the end of the url (which I figured out using:
=HYPERLINK("https://xxxxxxxx/cgi-bin/user_info.pl?search=xxxxxxxx&name=" &I2)
)
So I have the URL now for that, I want to be able to run a web query for
each record and have the unique URL for each record for the web query without
literally copy-pasting each one into the web query wizard.
An aside: I've never used macros before in Excel, so I need baby steps if
that's the case.
If you need more information to help me, please let me know, and thanks in
advance!
Nick
|