+ Reply to Thread
Results 1 to 7 of 7

Automate change of parameter in web query

  1. 10-13-2014, 02:26 PM #1
    ajeetsingh
    ajeetsingh is offline
    Registered User
    Join Date
    10-13-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    8

    Arrow Automate change of parameter in web query

    I have attached an excel sheet here.
    I want to change values of cell C6 after every (say)10 secs with values in C51:C200.
    Currently i am doing it manually with dropdown list.
    Please help with suitable macro.
    Test.xlsx
    Reply With QuoteRegister To Reply
  2. 10-13-2014, 03:04 PM #2
    bulina2k
    bulina2k is offline
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    861

    Re: Automate change of parameter in web query

    Take a look:
    Attached Files Attached Files
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you
    Reply With QuoteRegister To Reply
  3. 10-13-2014, 11:33 PM #3
    ajeetsingh
    ajeetsingh is offline
    Registered User
    Join Date
    10-13-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    8

    Re: Automate change of parameter in web query

    Quote Originally Posted by bulina2k View Post
    Take a look:
    Thanks for your generous effort but my sheet is 'NOT Responding' on clicking start.
    Please look into it
    Reply With QuoteRegister To Reply
  4. 10-14-2014, 03:17 AM #4
    bulina2k
    bulina2k is offline
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    861

    Re: Automate change of parameter in web query

    OK, new version:
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 10-14-2014, 12:24 PM #5
    ajeetsingh
    ajeetsingh is offline
    Registered User
    Join Date
    10-13-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    8

    Thumbs up Re: Automate change of parameter in web query

    Quote Originally Posted by bulina2k View Post
    OK, new version:
    Its working superb, thanks a lot !!!
    Can a button for pause/stop be added apart from start button?
    Last edited by ajeetsingh; 10-14-2014 at 12:29 PM.
    Reply With QuoteRegister To Reply
  6. 10-14-2014, 02:54 PM #6
    bulina2k
    bulina2k is offline
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    861

    Re: Automate change of parameter in web query

    Now with pause also:
    (click Add Reputation if you are satisfied with my answer)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 10-14-2014, 10:44 PM #7
    ajeetsingh
    ajeetsingh is offline
    Registered User
    Join Date
    10-13-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    8

    Thumbs up Re: Automate change of parameter in web query

    Quote Originally Posted by bulina2k View Post
    Now with pause also:
    Thanks a ton !!!
    (click Add Reputation if you are satisfied with my answer)
    Oh sure, added !!!
    ico-thanks.png
    All of my queries resolved !!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 'Driver]Parameter missing' Error while trying to pass parameter to MS query & Return Data
    By NiveaGM in forum Excel General
    Replies: 2
    Last Post: 10-06-2014, 08:15 AM
  2. 'Driver]Parameter missing' Error while trying to pass parameter to MS query & Return Data
    By NiveaGM in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-06-2014, 07:35 AM
  3. Parameter Query that takes parameter value from Excel Cell
    By Aquamore in forum Access Tables & Databases
    Replies: 1
    Last Post: 01-23-2014, 03:43 PM
  4. MS Query and a Conditional Parameter or Null as an In-Cell Parameter
    By scottclayton in forum Excel General
    Replies: 0
    Last Post: 11-12-2013, 03:57 AM
  5. Parameter Query - Bad Parameter Type
    By Kyle123 in forum Excel General
    Replies: 0
    Last Post: 04-23-2013, 01:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1