+ Reply to Thread
Results 1 to 2 of 2

pulling data from web with dynamic url

  1. #1
    Registered User
    Join Date
    06-07-2011
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    1

    pulling data from web with dynamic url

    Hi,

    I've looked around for solutions to this problem all over online, and have gotten close answers that somewhat work, but nothing that I can make work in my scenario.

    I basically want to have a column of values in excel that are inputted by the user. Each value is passed to a url (a php script on my own site), which will take that value, and return another value. I need the returned value to show in the next column over. The value returned can just be what the url returns (I won't use the php script for anything other than this project), so looking for tags isn't necessary. Also, I'd prefer to have a button be used to check and recheck the values. If you guys are curious as to what I'm trying to do, I want the excel file to contain a url, and the PHP script will check if it exists in a page, then return a "yes" or "no".

    The url might be something like www.mydomain.com/?s=[cell value]

    So, cell B1 might have the value of 62. The value of C1 is the result of www.mydomain.com/?s=62. I know my way around PHP very well, but unfortunately, I don't know my way around VBA well at all

    Thanks in advance for any help.

  2. #2
    Valued Forum Contributor
    Join Date
    05-21-2009
    Location
    Great Britain
    MS-Off Ver
    Excel 2003
    Posts
    550

    Re: pulling data from web with dynamic url

    Maybe this:
    Please Login or Register  to view this content.
    Post responsibly. Search for excelforum.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to create a dynamic chart off dynamic data
    By jananas in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-07-2013, 10:48 AM
  2. Pulling values from one sheet to another sheet that is entirely dynamic
    By vegasboy423 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-25-2013, 03:59 PM
  3. Pulling a Specific Cell when Pulling a Tabel from Web Based Data
    By Zallen89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2013, 05:39 PM
  4. [SOLVED] Pulling data from a separate sheet by date and sheet title (dynamic)
    By Adsup01 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-13-2012, 06:02 PM
  5. [SOLVED] Mutliple SUM with dynamic SUM range within a Dynamic Data set
    By Michael.Westen in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-10-2012, 06:28 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1