Results 1 to 7 of 7

Thread: Excel - Cards

  1. Jan 5th, 2008, 05:34 PM #1
    dbasnett
    dbasnett is offline

    Thread Starter
    Powered By Medtronic dbasnett's Avatar
    Join Date
    Dec 2007
    Location
    Jefferson City, MO
    Posts
    9,897

    Excel - Cards

    After following this thread http://www.vbforums.com/showthread.php?t=501535 I became curious about cards.

    I spent a couple of hours over the last two days throwing something together in Excel / VBA.

    If any one wants to have the Workbook I'll be glad to post it here if I can figure out how to do it and if it is allowed.
    My First Computer -- Documentation Link (RT?M) -- Using the Debugger -- Prime Number Sieve
    Counting Bits -- Subnet Calculator -- UI Guidelines -- >> SerialPort Answer <<
    "Those who use Application.DoEvents have no idea what it does and those who know what it does never use it." John Wein
    Reply With Quote Reply With Quote
  2. Jan 5th, 2008, 05:37 PM #2
    Greyskull
    Greyskull is offline
    Hyperactive Member Greyskull's Avatar
    Join Date
    Dec 2003
    Location
    somewhere in England
    Posts
    382

    Re: Excel - Cards

    How bout sending it through email? I was going to build something like that as well out of curiosity
    Please go to the Thread Tools menu and click Mark Thread Resolved when your post is answered
    If someone helped you today then please consider rating their post.
    Reply With Quote Reply With Quote
  3. Jan 5th, 2008, 05:44 PM #3
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Excel - Cards

    If you have a finished code then you can attach it to a thread in the Code Bank - Other forum. Or just post the VBA code needed as it doesnt have to be an attachment if you dont want it to be but not everyone may have Excel so if its code they can at least see/read the code.
    VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    • Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
    Reply With Quote Reply With Quote
  4. Jan 5th, 2008, 05:53 PM #4
    dbasnett
    dbasnett is offline

    Thread Starter
    Powered By Medtronic dbasnett's Avatar
    Join Date
    Dec 2007
    Location
    Jefferson City, MO
    Posts
    9,897

    Re: Excel - Cards

    It is dependent on Excel. I'll atach it, and people can open it without enabling macros and examine the code if they want.

    BTW - It isn't pretty code because I was interested in 'card aspect' of it. If I had it to do for real it would be different.

    Attachment 61481
    Last edited by dbasnett; Feb 6th, 2008 at 10:51 PM.
    My First Computer -- Documentation Link (RT?M) -- Using the Debugger -- Prime Number Sieve
    Counting Bits -- Subnet Calculator -- UI Guidelines -- >> SerialPort Answer <<
    "Those who use Application.DoEvents have no idea what it does and those who know what it does never use it." John Wein
    Reply With Quote Reply With Quote
  6. Jan 5th, 2008, 06:03 PM #5
    Greyskull
    Greyskull is offline
    Hyperactive Member Greyskull's Avatar
    Join Date
    Dec 2003
    Location
    somewhere in England
    Posts
    382

    Re: Excel - Cards

    Nice. This should be worth putting in the codebank Nice work there mate.
    Please go to the Thread Tools menu and click Mark Thread Resolved when your post is answered
    If someone helped you today then please consider rating their post.
    Reply With Quote Reply With Quote
  7. Jan 5th, 2008, 09:37 PM #6
    dbasnett
    dbasnett is offline

    Thread Starter
    Powered By Medtronic dbasnett's Avatar
    Join Date
    Dec 2007
    Location
    Jefferson City, MO
    Posts
    9,897

    Re: Excel - Cards

    Thank you. It was interesting that the statistics for hand distribution I found on the net and the ones that I arrived at from playing were so close.

    Last night I put it on Auto / Fast and it played almost 200,000 hands.
    My First Computer -- Documentation Link (RT?M) -- Using the Debugger -- Prime Number Sieve
    Counting Bits -- Subnet Calculator -- UI Guidelines -- >> SerialPort Answer <<
    "Those who use Application.DoEvents have no idea what it does and those who know what it does never use it." John Wein
    Reply With Quote Reply With Quote
  8. Feb 27th, 2008, 05:11 PM #7
    Robert Fraser
    Robert Fraser is offline
    New Member
    Join Date
    Feb 2008
    Posts
    1

    Re: Excel - Cards

    Is the link to this attachment still available? I'm doing a Texas Hold Em simulation, and this looks very helpful.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width