Starting Explorer from VBA
 

Rob,

Absolutely not, if anything from my experience of you I would say you are
overly self-effacing<G.

I was trying to point out that I was really addressing the OP and that there
was no for you to justify yourself or anything else.

It's tricky this communication, so many opportunities for
mis-understandings<vbg. No wonder we are coders.

Best Regards

Bob

"Rob van Gelder" wrote in message
...
Did I come across defensively? I apologise.

I appreciate it when people correct me with a more elegant answer - it
gives
me opportunity to learn.

Thanks :)

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bob Phillips" wrote in message
...
Rob,

I was just offering the OP an alternative.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Starting Explorer from VBA
 

Thanks.
Yes, I agree about this tricky communication. It has gotten better since the
two tones of the past (speaking and SHOUTING).

I've got a fair amount of programming experience but the frequent posters
have a lot of teach me yet - I'm relatively new here so I don't want to
steps on toes and lose that opportunity. (I've learned so much already!)

Cheers

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bob Phillips" wrote in message
...
Rob,

Absolutely not, if anything from my experience of you I would say you are
overly self-effacing<G.

I was trying to point out that I was really addressing the OP and that
there
was no for you to justify yourself or anything else.

It's tricky this communication, so many opportunities for
mis-understandings<vbg. No wonder we are coders.

Best Regards

Bob

"Rob van Gelder" wrote in message
...
Did I come across defensively? I apologise.

I appreciate it when people correct me with a more elegant answer - it
gives
me opportunity to learn.

Thanks :)

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bob Phillips" wrote in message
...
Rob,

I was just offering the OP an alternative.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Starting Explorer from VBA
 

Hey Rob,

So right. By the way, I visited your site and took a look at the picture
gallery. There seemed to be a significant omission there?

Bob

"Rob van Gelder" wrote in message
...
Thanks.
Yes, I agree about this tricky communication. It has gotten better since
the
two tones of the past (speaking and SHOUTING).

I've got a fair amount of programming experience but the frequent posters
have a lot of teach me yet - I'm relatively new here so I don't want to
steps on toes and lose that opportunity. (I've learned so much already!)

Cheers

--
Rob van Gelder - http://www.vangelder.co.nz/excel

Starting Explorer from VBA
 

Rob

I downloaded your Blackjack.bas file and i get an error message sayin
COMPILE ERROR EXPECTED: IDENTIFYER on

Private Enum GameStat

--
Message posted from http://www.ExcelForum.com

Starting Explorer from VBA
 

What's your version of Excel?

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"mudraker " wrote in message
...
Rob

I downloaded your Blackjack.bas file and i get an error message saying
COMPILE ERROR EXPECTED: IDENTIFYER on

Private Enum GameState


---
Message posted from http://www.ExcelForum.com/

Starting Explorer from VBA
 

Indeed. I'll update soon :)

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bob Phillips" wrote in message
...
Hey Rob,

So right. By the way, I visited your site and took a look at the picture
gallery. There seemed to be a significant omission there?

Bob

"Rob van Gelder" wrote in message
...
Thanks.
Yes, I agree about this tricky communication. It has gotten better since
the
two tones of the past (speaking and SHOUTING).

I've got a fair amount of programming experience but the frequent
posters
have a lot of teach me yet - I'm relatively new here so I don't want to
steps on toes and lose that opportunity. (I've learned so much already!)

Cheers

--
Rob van Gelder - http://www.vangelder.co.nz/excel

Starting Explorer from VBA
 

Enum is not supported in Excel97 VBA and I don't have it to test
unfortunately.

You could try the following:
Replace:
Private Enum GameState
gstWaitingToDeal = 0
gstPlayerHand1 = 1
gstPlayerHand2 = 2
gstDealerHand = 3
End Enum

With:
Const gstWaitingToDeal = 0
Const gstPlayerHand1 = 1
Const gstPlayerHand2 = 2
Const gstDealerHand = 3

and

Replace:
Private CurrentGameState As GameState

With:
Private CurrentGameState As Long


Please let me know how that goes? If it works OK, I'll likely update the
code. Might as well be 97 compatible if the differences are that minor.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"mudraker " wrote in message
...
Rob

I downloaded your Blackjack.bas file and i get an error message saying
COMPILE ERROR EXPECTED: IDENTIFYER on

Private Enum GameState


---
Message posted from http://www.ExcelForum.com/

Starting Explorer from VBA
 

Rob

I am using 97 and your suggested changes work very nicely

thank

--
Message posted from http://www.ExcelForum.com