Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 192
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Missing from Excel Cell When Query through C# [email protected] Excel Discussion (Misc queries) 0 March 28th 07 09:08 PM
Keep cell data with records from a query Secret Squirrel Excel Discussion (Misc queries) 2 January 26th 07 10:46 PM
Keeping cell data with records from a query Secret Squirrel Excel Discussion (Misc queries) 0 January 23rd 07 05:41 PM
How do I set cell colors based on if query Wullie Excel Worksheet Functions 3 April 2nd 06 10:36 PM
color coordinate web query data based on the number being + or - Ukemann Excel Discussion (Misc queries) 1 February 9th 06 08:15 PM


All times are GMT +1. The time now is 02:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"