try using
Application.OnTime method
http://www.ozgrid.com/Excel/run-macro-on-time.htm
http://www.cpearson.com/excel/OnTime.aspx
On Mon, May 9, 2011 at 1:17 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:
> Hi All,
>
>
>
> I am having one database which is link to the external data
Hi All,
I am having one database which is link to the external data (Internet)... I
need the VBA code where the data will automatically refresh after 30 seconds /
15 Seconds, but it should not be a loop it just a macro automatically running
after 15 sec.
Example : My data is refreshed at 11:44
Sub Macro1()
ActiveWorkbook.RefreshAll
Call Update
End Sub
Sub Update()
Application.Wait Now + TimeValue("00:01:00")
Call Macro1
End Sub
On Wed, Mar 30, 2011 at 9:54 AM, Divaker Pandey wrote:
> can u send that file.
>
> Divaker
>
>
> On Tue, Mar 29, 2011 at 2:40 PM, Anil Bhange <
> anil.bha...
can u send that file.
Divaker
On Tue, Mar 29, 2011 at 2:40 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:
> Hi Expert,
>
>
>
> Some of my excel sheet has linked with Internet which requires live auto
> updation, by default I can do 1 min refresh…
>
>
>
> Could you help me with any
Hi Expert,
Some of my excel sheet has linked with Internet which requires live auto
updation, by default I can do 1 min refresh...
Could you help me with any VB code where I can do it on live basis and at
background excel update the data.
Thanks & Regards,
Anil Bhange
IP - 512320
--
---
