Results 1 to 14 of 14
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA subject/thread

    To those of you who knew me as, I think, "cgreaves" ...

    I'm considering trying again to post ALL my utility procedures (functions/subroutines) from my VBA collection. I'd only just got started before the Lounge threw them all away, but I'm not carrying any resentments about that ....(g!)

    I'm talking maybe 1,000 unique procedures here, some of the rudimentary (like the strReplaceAll type of thing) and some of them more complex where they really depend on previously published code (I'm thinking of my code that uses compressed space characters to insert a signature in any document).

    Looking down the road this could be a library of code, such that we could refer to the NAME of a procedure, and a search of the VBA forum would locate that code very quickly, together with any feedback/improvements on that code.

    Before I wade in here, have you any thoughts on the matter?
    Is it worth having a separate forum as a searchable library of code?

    Should we distinguish between VBA code that is generic (string-handling, as an example) and that code which is vehicle-dependant (such as stuff that deals with a Word ActiveDocument)?

    How about a preferred subject line? Should all posts with original sample code have "sample" as the first word?

    If I propose a naming convention, will there be heated debates about "str" vs. "txt" as prefixes?


    In all of this I'm looking to gain more from it than you; my focus on submitting sample code is to improve my coding by getting your feedback; it is, therefore, in my interests to present the code in a manner acceptable to you, the readers.

    Blame Geoff Wossname from the sheep station for getting me back.

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA subject/thread

    To me, VBA Help pretty much does all I need it to do in that respect. In general, I have no idea what function to use in a particular instance, so posting in the appropriate group does wonders for me, (Woody's Lounge, and it's knowledgable inhabitants have virtually built my Excel application, and I learned TONS in the process...) [img]/w3timages/icons/grin.gif[/img] with 1,000 unique procedures, I may not know where to start, and with such a vast resource in the insanely intelligent individuals around here, I wouldn't see myself using it.. of course, that's just my [img]/w3timages/icons/2cents.gif[/img]...

    Drk.
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  3. #3
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA subject/thread

    Chris,

    Great to see you back again. Welcome to the new forum.

    Hey, what's this "Geoff Wossname from the sheep station" rubbish? I gather that's the Canadian icicles on your fingers affecting you there.

    For those in the UK- apparently Chris's "indexer" utility (just one of the utilities on his website has been reviewed in the British edition of PCW- page 251 or thereabouts? If anyone has seen it, it might be worth sharing it.

    That's a very generous offer to be posting code like that.

    My suggestion would be to post the code, get it discussed, then when you're happy with a piece of code, put it on your own web site.

    Geoff
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  4. #4
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA subject/thread

    Chris,


    Welcome back! Good to here your "voice" again. And thanks for all the great posts in the past.

    Your idea is a good one; however it would change the scope of the Lounge and that would be up to Woody, etc. to decide. I like Geoff's idea -- and you get hits to your site out of it -- to post code mods, functions (heck, whole apps as far as I'm concerned) on your web site. We'll get 'em there and thank you all the same.

    Keep posting!
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: VBA subject/thread

    Chris,
    Nothing to add really (I think the code library's a good idea) just saying hi. You'll like this incarnation of the Lounge - no slowdown (as yet [img]/w3timages/icons/grin.gif[/img])
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles, California, USA
    Posts
    1,734
    Thanks
    0
    Thanked 3 Times in 1 Post

    Re: VBA subject/thread

    Hi Chris, Welcome Home. [img]/w3timages/icons/trophy.gif[/img]
    That's a splendid offer and Woody and Claude both agree that it would most definitely be a valuable addition to the Lounge.
    What I propose is a special 'Code Library' board - maybe even 'Chris Greaves Code Library'. I could make it a Reply-Only board so that only you as Moderator could start a new thread although the Loungers could respond with feedback. This would keep it neat and clean and you could set your own naming conventions without debate.

    Give me your nod and I'll fix it right away. (And thanks!)
    <IMG SRC=http://www.wopr.com/w3tuserpics/Eileen_sig.gif>

  7. #7
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles, California, USA
    Posts
    1,734
    Thanks
    0
    Thanked 3 Times in 1 Post

    Re: VBA subject/thread

    I hate to be a killjoy because I love Calvin and Hobbes but they ARE copyrighted and you may be in trouble using them...

    (My favorite is when he puts up in hand in class to say "I have to go!" - then goes - home.)
    <IMG SRC=http://www.wopr.com/w3tuserpics/Eileen_sig.gif>

  8. #8
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: VBA subject/thread

    I did wonder about that - I'll go back and check the site I found them on. I assumed (probably wrongly) that they had permission to create them and give them away.
    I do have all the books so perhaps they'll let me off?
    Regards,
    Rory

    Microsoft MVP - Excel

  9. #9
    KTYorke
    Guest

    Re: VBA subject/thread

    The BEST Calvin and Hobbes is in the winter time when he builds his snowmen... I still laugh out loud when I think of them!!

    Especially when he builds the snowman that was run over by his dad's car and about three shocked snowmen witnesses!!
    Wish I could find them again! [img]/w3timages/icons/laugh.gif[/img]

    BTW Welcome back Chris!! Glad to have your KB back!!
    have fun

  10. #10
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA subject/thread

    > What I propose is a special 'Code Library' board - maybe even 'Chris Greaves Code Library'. I could make it a Reply-Only board so that only you as Moderator could start a new thread although the Loungers could respond with feedback. This would keep it neat and clean and you could set your own naming conventions without debate.
    I've been thinking about this. It wasn't my intention to set up the Chris Greaves Memorial board.
    I feel that the VBA forum is probably as good a place as any. I didn't want to flood the VBA-place-to-ask-questions with a technical elite debating the esoteric (to the newcomer) merits of using the $-style string function.
    I believe that there's a place both for the newcomer (which is, after all, who I am from time-to-time) and the penny-pinching bit-squeezing miser (which is, after all, who I am from time-to-time).
    Whatever its form, a Code Library has two apealing aspects:-
    1) It serves as a solid testing-ground for ideas about very low-level coding techniques; a single submission is trailed by the pros and cons of specific ideas (use of the $-style string function, use of FOR vs. While etc.)
    2) It serves as a repository for high-utility code; we see this often where someone responds with "go look for Geoff's strTest function" or similar.
    Geoff's idea of a link to a web page is good, but I detest having to click yet once again to get what I want, and now I'd have the original procedure plus discussion on Woody's Lounge, and the final result somewhere else. What would make sense for me is to have the basic code and discussion on Woody's lounge and at the insitgator's option, a link to a template on the instigator's site where the procedure can be seen at work ina real albeit stripped-down version. For example, I might post my strSignature procedure that generates a compressed-space numeric signature, and then on my web site post a template with enough supporting code to show the little devil at work in a real document.
    Perhaps we could just continue the way we are/were with a subject line prefix of "sample" (or shorter, "code"?) to warn the user that here follows some down-and-dirty nit-picking.
    To that end, what is the possibility at a later date of streaming all messages prefaced with a specific string off into a separate forum, should the need arise? How easy is it to move a set of say, eight therads, maybe 900 messages, into a separate forum called "Code Examination"?
    I'm taking time to contemplate this because some sites (planet-source) already maintain searchable data bases of VB code, although not specifically VBA code, with dialogue. Not much point in duplicating that, and anyway, Woody's Lounge always was better.
    I'm thinking too of my earlier efforts, which were rewarded with much valuable feedback (thanks Guys!), but I never seemed to be able to wreap up a discussion with a "final result".
    Still thinking, but wanting to get going, maybe I'll just start posting code and encouraging others to adopt a like standard and see what happens. I'm mainly wary of flooding a forum, a sort-of-spam, and turning people away.
    In the old Ilink-BBS conference on MS-Word it was awkward reconciling the purists/fanatics with those who just wanted to get the job done.
    Thanks again to all those who responded.

  11. #11
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA subject/thread

    Geoff and Kevin et al. (good old Al!) thanks for the responses/encouragements. Please see my weighty reply to Eileen.

    I hope to trot out some stuff this week.

    It has cleared my mind, because I always wanted to contribute code in return for the help I got/get here, but didn't want to post compund stuff, just low-level code. But then, how to show how/why it is useful?

    The answer is probably a hybrid, with low-level code posted here, and then higher-level examples, showing how it can be used in a mini-application, posted on my web site, or some web site at any rate.

  12. #12
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles, California, USA
    Posts
    1,734
    Thanks
    0
    Thanked 3 Times in 1 Post

    Re: VBA subject/thread

    Sounds feasible to me. Go ahead and start posting it. Use the shortest preface you can think of - "Code:" will do nicely. Put each snippet on whatever board it is most relevant and we'll see how it runs. The next step will become evident as we proceed.
    <IMG SRC=http://www.wopr.com/w3tuserpics/Eileen_sig.gif>

  13. #13
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA subject/thread

    I'm going to start posting in the VBA forum with subject headers that begin with "Code:" as per Eileen's suggestion. We will see where we go from there.

  14. #14
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA subject/thread

    Great!

    Looking forward to it.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

Posting Permissions

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