ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Web query url based on data in cell (https://www.excelbanter.com/excel-discussion-misc-queries/159642-web-query-url-based-data-cell.html)

nick

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


All times are GMT +1. The time now is 12:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com