Is BetAngel connected to Excel?

[GaryCook]

HI,

Is there anyway to tell a Excel VBA macro that Bet Angel is connected to Excel?
Or more specifically, has been reconnected. Ie, stopped and connected again.

[sa7med]

HI,

Is there anyway to tell a Excel VBA macro that Bet Angel is connected to Excel?
Or more specifically, has been reconnected. Ie, stopped and connected again.

If you keep a log of updates, you could look at the time between updates using the worksheet change event.

[GaryCook]

HI,

Is there anyway to tell a Excel VBA macro that Bet Angel is connected to Excel?
Or more specifically, has been reconnected. Ie, stopped and connected again.

If you keep a log of updates, you could look at the time between updates using the worksheet change event.

Great idea actually thanks.

Thought of something similar but that's better than my idea.

To be honest I wish BA could pass some things like this straight into a variable.

[jimibt]

To be honest I wish BA could pass some things like this straight into a variable.

in effect, you could create a global variable (g_lastRefreshTime) of type datetime and everytime the worksheet_change event is fired, you'd update this variable with the current time. thereafter, you could at any place in your code query the difference between the current time and the g_lastRefreshTime and determine if your next action was valid, based on known limits between current and g_lastRefreshTime.

[edit] - or a better option; create a global class that contains this variable and simply returns status values which will allow you to take action if required.

[GaryCook]

I just had a thought. The challenge is for me its still going to fire because of BA ques the updates when something like VBA MsgBox has triggered a pause.

[sa7med]

I just had a thought. The challenge is for me its still going to fire because of BA ques the updates when something like VBA MsgBox has triggered a pause.

Rather than a msgbox in excel, you can shoot a stored value from excel into BA and have that trigger an alert? Haven't done excel to BA stored values yet but it seems its possible in newest version. Other option is to play a sound file and show your alert on a dashboard sheet.

[GaryCook]

I just had a thought. The challenge is for me its still going to fire because of BA ques the updates when something like VBA MsgBox has triggered a pause.

Rather than a msgbox in excel, you can shoot a stored value from excel into BA and have that trigger an alert? Haven't done excel to BA stored values yet but it seems its possible in newest version. Other option is to play a sound file and show your alert on a dashboard sheet.

Been doing that for other functions but for this one im not sure of the workflow yet.

Mostly im trying to write the foundation for new macros so I dont accidentally end up trying to debug a race that is over ETC.

Spent a couple of hours doing that this morning.
I was like why are my variables not assigned and it took me too long to remember I was working on an old race.

Since BA wasn't writing to Excel since the race had expired my Worksheet onChange was not firing.