Excel Automated...

[osknows]

I'm having a REALLY bad day today...everything I touch is wrong in some way!

Spot the deliberate mistake... I left out If 'Target.Columns.count = 16 Then'

Here is corrected version yet again...
http://www.mediafire.com/file/oameoajnzy2/Book11.xls

Apologies.. must improve multi-tasking skills

[mak]

Thanks Os, it is working fine ( i am testing all day ).
I have to wait until tomorrow to see that it will refresh the markets.

I will let you know

[mak]

Well, the market haven't been updated.Any ideas?

[osknows]

Hi Mak,

I'm away for a few days so will look at this when I get home on Monday.

Have a good weekend
Os

[mak]

Hi Os, have a nice weekend too (and Happy Easter?)

[osknows]

I told you everything I touched that day was wrong! I put the Workbook_Open event in the MODULE and it should have been in the THISWORKBOOK.

Here is correction which I've tested an works fine http://www.mediafire.com/?do2wjcllyut

All the best, Os

[mak]

Os, it is working Fine.Thank you.
My only problem is that for some reason it still misses 1 market if there are 2 markets at excactly the same time, and i don't want to open each market at a new tab.Have you got any suggestions?

[osknows]

I pretty certain that you need seperate tabs if markets begin at the same time

[mak]

i have to watch it some more days i think because today it worked, & placed bets at both markets

[osknows]

Thinking about it.... it depends on the timings you set in the coding. The timer will hold off until 20mins before the market commences then advance to the next market every 20 minutes. Therfore, you could be advancing to the next market (when 2 are at the same time) as the next one is about to or already started?

[mak]

Well i just check the code at your file & i am still using the

Const triggerduration As Integer = 1 'trigger every 20 minutes
Const timebeforeevent As Integer = 20 'monitor event only 20 minutes before start

probably this is doing the trick. it runs exactly as i want & it placed the bets
i am thinking to try it at 0.5 tomorrow

[osknows]

Well i just check the code at your file & i am still using the

Const triggerduration As Integer = 1 'trigger every 20 minutes
Const timebeforeevent As Integer = 20 'monitor event only 20 minutes before start

probably this is doing the trick. it runs exactly as i want & it placed the bets
i am thinking to try it at 0.5 tomorrow

That is still set up for testing to run every 1 minute, I forgot to change the comments when testing..!!

So this will trigger every minute

Const triggerduration As Integer = 1 'trigger every 1 minutes

if you want to run every 20mins

Const triggerduration As Integer = 20 'trigger every 20 minutes

[mak]

Well i just check the code at your file & i am still using the

Const triggerduration As Integer = 1 'trigger every 20 minutes
Const timebeforeevent As Integer = 20 'monitor event only 20 minutes before start

probably this is doing the trick. it runs exactly as i want & it placed the bets
i am thinking to try it at 0.5 tomorrow

That is still set up for testing to run every 1 minute, I forgot to change the comments when testing..!!

So this will trigger every minute

Const triggerduration As Integer = 1 'trigger every 1 minutes

if you want to run every 20mins

Const triggerduration As Integer = 20 'trigger every 20 minutes

yes i know.
but it still monitors the markets with this one every 20 minutes
Const timebeforeevent As Integer = 20 'monitor event only 20 minutes before start

& i dont mind how fast it will pass the markets.
will it recognize the 0.5 ?

[osknows]

Yes, effectively it converts into seconds so 0.5 minutes * 60 = 30secs