General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
06 Feb 13
10:32
Joined:
Date Joined:
14 Aug 07
I 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 comes to writing and implementing VBA so would be grateful for a FULL explanation.
Thanks
I assume it will need a short bit of VBA – I am a novice when it comes to writing and implementing VBA so would be grateful for a FULL explanation.
Thanks
Show More
You will need to do what's described here.
http://www.cpearson.com/excel/OnTime.aspx
http://www.cpearson.com/excel/OnTime.aspx
Thanks 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: " point
Do ypu know of any links that show how to run an on time event that gives FULL details?
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: " point
Do ypu know of any links that show how to run an on time event that gives FULL details?
Google is your friend
What 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.
What 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.
Thanks 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).
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).
I still haven't sussed this out - can anyone point me in the right direction?
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539