+ Reply to Thread
Results 1 to 2 of 2

Assigning a cell value in web query connection

  1. #1
    Registered User
    Join Date
    02-07-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    53

    Assigning a cell value in web query connection

    HI,
    I have a macro which retrieves data from web.It works fine.I just don't know how to assign a cell value in web address.i have attached the code here.
    i just want to assign activesheet.(range"c2").value for "q?s". Can anybody help me on this issue?


    Please Login or Register  to view this content.

    thanks

    Netaji

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Assigning a cell value in web query connection

    Is this solved?

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. Replies: 0
    Last Post: 04-12-2013, 10:16 AM
  2. [SOLVED] Using Cell Value In Web Query Connection
    By rlee12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2013, 03:56 AM
  3. [SOLVED] Query connection referring to a cell value
    By ranald in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-14-2012, 04:42 AM
  4. Web query connection referencing a cell
    By rs585832 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-13-2012, 02:16 PM
  5. Web Query using ADO(?) connection
    By reloader in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-19-2006, 05:25 PM

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