General Betting
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
sort by:
Show
per page
Replies: 6
|
By:
You will need to do what's described here.
http://www.cpearson.com/excel/OnTime.aspx |
|
By:
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? |
|
By:
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. |
|
By:
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). |
|
By:
I still haven't sussed this out - can anyone point me in the right direction?
 |
|
By:
include youtube as a keyword judge, in a google search, and watch how its done.
|