New Posts For Thread: Excel question: How to increase the frequency of web query refreshes?https://community.betfair.com/general_betting/go/thread/view/94082/29761175/excel-question-how-to-increase-the-frequency-of-web-query-refreshesI am trying to pull in some data from an external website using web query but it only allows for a refresh a maximum of once per minute. Can anyone advise me how to increase this?I assume it will need a short bit of VBA – I am a novice when it comeinclude youtube as a keyword judge, in a google search, and watch how its done.https://community.betfair.com/general_betting/go/thread/view/94082/29761175/excel-question-how-to-increase-the-frequency-of-web-query-refreshes?post_id=529266511#529266511include youtube as a keyword judge, in a google search, and watch how its done.Fri, 22 Feb 2013 14:50:55 -0600I still haven't sussed this out - can anyone point me in the right direction?https://community.betfair.com/general_betting/go/thread/view/94082/29761175/excel-question-how-to-increase-the-frequency-of-web-query-refreshes?post_id=529255629#529255629I still haven't sussed this out - can anyone point me in the right direction?Fri, 22 Feb 2013 08:51:29 -0600Thanks for the reply Stow, I am using Excel 2010.The info on the link provided leads me to the same problem, ie. the lowest you can set the web query refresh to is 1 minute (if you try to put a lower number in like 0.5 it won't accept it).https://community.betfair.com/general_betting/go/thread/view/94082/29761175/excel-question-how-to-increase-the-frequency-of-web-query-refreshes?post_id=528829761#528829761Thanks for the reply Stow, I am using Excel 2010.The info on the link provided leads me to the same problem, ie. the lowest you can set the web query refresh to is 1 minute (if you try to put a lower number in like 0.5 it won't accept it).Thu, 07 Feb 2013 03:19:56 -0600Google is your friendWhat version of excel are you running?https://askdrexel.drexel.edu/app/answers/detail/a_id/2513/~/how-to%3A-refresh-data-automatically-at-regular-time-intervals-in-excel-2007.https://community.betfair.com/general_betting/go/thread/view/94082/29761175/excel-question-how-to-increase-the-frequency-of-web-query-refreshes?post_id=528812095#528812095Google is your friendWhat version of excel are you running?https://askdrexel.drexel.edu/app/answers/detail/a_id/2513/~/how-to%3A-refresh-data-automatically-at-regular-time-intervals-in-excel-2007.Wed, 06 Feb 2013 11:01:56 -0600Thanks for the link Ian.Unfortunately, I was lost at the "For example, declare Public variables in a standard code module, outside of and before any procedure (Sub or Function) declaration: " pointDo ypu know of any links that show how to run an on thttps://community.betfair.com/general_betting/go/thread/view/94082/29761175/excel-question-how-to-increase-the-frequency-of-web-query-refreshes?post_id=528804793#528804793Thanks for the link Ian.Unfortunately, I was lost at the "For example, declare Public variables in a standard code module, outside of and before any procedure (Sub or Function) declaration: " pointDo ypu know of any links that show how to run an on tWed, 06 Feb 2013 05:47:59 -0600You will need to do what's described here.http://www.cpearson.com/excel/OnTime.aspxhttps://community.betfair.com/general_betting/go/thread/view/94082/29761175/excel-question-how-to-increase-the-frequency-of-web-query-refreshes?post_id=528804465#528804465You will need to do what's described here.http://www.cpearson.com/excel/OnTime.aspxWed, 06 Feb 2013 05:25:01 -0600I am trying to pull in some data from an external website using web query but it only allows for a refresh a maximum of once per minute. Can anyone advise me how to increase this?I assume it will need a short bit of VBA – I am a novice when it comehttps://community.betfair.com/general_betting/go/thread/view/94082/29761175/excel-question-how-to-increase-the-frequency-of-web-query-refreshes?post_id=528803775#528803775I am trying to pull in some data from an external website using web query but it only allows for a refresh a maximum of once per minute. Can anyone advise me how to increase this?I assume it will need a short bit of VBA – I am a novice when it comeWed, 06 Feb 2013 04:32:52 -0600