LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default Symbols for playing cards

Hi all
I am writing a program to generate a dealing file for bridge to deal hands
using a dealing machine which physically deals the hands for tournament
bridge (.DGE format for those who might know).

I need to insert the suit symbols:
e.g spade (#170), heart(#169), diamond(#168) or club(#167) character
I have a variable (string) called HandText that I need to add a set of
characters to.
When I run the following:
HandText = HandText + Chr(170)
HandText = HandText + "A"
HandText = HandText + "6" etc.
This is the output I get
'ªA652©QJ5¨KQT8§T4
to represent the hand,
(Spade)A652(Heart)QJ5(Diamond)KQT8(Club)T4

The dealing machine program gives me an an error as it seems to need the
actual spade symbol.

What do I need to do to the line
HandText = HandText + Chr(170)
to get an actual spade symbol?
Do I format the text as Symbol? If so how?

Peter Bircher


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Symbols on the keyboard are not the symbols on the screen.... Lisha Excel Discussion (Misc queries) 2 May 22nd 10 07:29 AM
Detecting the actual playing or NOT playing of a WAV file Bajbaj Excel Discussion (Misc queries) 0 October 24th 07 09:16 PM
playing sound??? tess457[_6_] Excel Programming 2 October 20th 04 11:50 AM
Playing music Naveen Sukhramani Excel Programming 2 July 26th 04 02:20 PM
Playing a .wav when a cell's value changes Jimm L Excel Programming 3 January 29th 04 04:10 PM


All times are GMT +1. The time now is 03:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"