![]() |
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