Help! Time Looped Macros

[diqbal]

I want to create a macro that emulates the clicking of a plugin button every 6 minutes. The specific plugin is the MSN Stock Quote Plugin for Excel found here:

http://www.microsoft.com/downloads/...D8-9305-4535-B939-3BF0A740A9B1&displaylang=EN

I tried to record a macro that does just that, but it doesn't record anything at all? Is this possible to do? Thanks in advance.

 

[diqbal]

There doesnt seem to be any shortcuts to anything except the Data menu

 

[Gettingbetter]

Is there no little lines under any of the letters under the words.

What Im after is how you would click it if you didnt have a mouse.

hope that make sence.

ie if I was trying to put clipart in without a mouse I would click

Alt I
P
C

I need to know this for getting to yours

 

[diqbal]

Data (Alt D) -> Stock Quotes from MSN Money (Q) -> Update Quotes (U)

and that needs to happen every 6 minutes. Thanks a lot man.

 

[Gettingbetter]

Write,

I may be repeating myself now but we can have it sorted here

Here we go

first of all in VBA double click on this workbook (It appears under the sheets, above the forms and macros.)

and input this

Private Sub Workbook_Open()
Reset
End Sub

then in a module stick

Sub Reset()
Static SchedSave
If SchedSave <> 0 Then
On Error Resume Next
Application.OnTime SchedSave, "Macro1", , False
End If
SchedSave = Now + TimeValue("00:06:00") ' changed to 6 minutes
Application.OnTime SchedSave, "Macro1", , True
End Sub

The above assumes that Macro1 contains the code to update your Stock.
Change this if its not macro1.

Now where we had
Application.CommandBars.FindControl(ID:=1).Execute

in your macro (which is Macro1 in my example)

wipe that and in its place put
SendKeys ("%DQU"), True

This should now work every 6 mins

Cheers

 

[diqbal]

It executed and did what it was supposed to do, but never did it again 6 minutes later?