Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Missing from Excel Cell When Query through C# | Excel Discussion (Misc queries) | |||
Keep cell data with records from a query | Excel Discussion (Misc queries) | |||
Keeping cell data with records from a query | Excel Discussion (Misc queries) | |||
How do I set cell colors based on if query | Excel Worksheet Functions | |||
color coordinate web query data based on the number being + or - | Excel Discussion (Misc queries) |