Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Cumberland, Maryland, USA
    Posts
    880
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Compilation of macros?

    Probably much too time consuming to do and maybe not of much interest to others (how's that for setting up a negative response?), but here goes anyway: During the time I've been foraging the Forum, a number (many numbers) of macros have been suggested and used with great success. Is there a way of perhaps compiling and posting them in the star posts? Maybe a macro to collect all the macros?

    Just a thought.

  2. #2
    Uranium Lounger viking33's Avatar
    Join Date
    Jun 2002
    Location
    Cape Cod, Massachusetts, USA
    Posts
    6,308
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Compilation of macros?

    DenGar,
    Yep, "Probably much too time consuming to do and maybe not of much interest to others." I agree. <img src=/S/frank.gif border=0 alt=frank width=15 height=15> <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    BOB
    http://lounge.windowssecrets.com/S/flags/USA.gif http://lounge.windowssecrets.com/S/f...sachusetts.gif


    Long ago, there was a time when men cursed and beat on the ground with sticks. It was called witchcraft.
    Today it is called golf!

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Compilation of macros?

    > Maybe a macro to collect all the macros?

    We can call it The One Macro, and hope that it is used only for good and not evil.

    (What DVD did I just buy? <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15> )

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Cumberland, Maryland, USA
    Posts
    880
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compilation of macros?

    Ah, well, just a thought. <img src=/S/sorry.gif border=0 alt=sorry width=15 height=15>

  5. #5
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Compilation of macros?

    Really, I'd love to be able to do it, but even just for Word, the number of posts is staggering, and there's no way to know from the outside which ones have viable code in them. <img src=/S/yikes.gif border=0 alt=yikes width=15 height=15> Then there would be the challenge of documenting what they do and what versions they were tested with. <img src=/S/sad.gif border=0 alt=sad width=15 height=15> indeed.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Compilation of macros?

    Thee Macros for the Outlook users to send their mail,
    Seven for the Word wizards to click with their mouse,
    Nine for Access programmers doomed to fail.
    One for Bill Gates in his Lake Washington house
    In the land of Microsoft where the Software lies
    One Macro to rule them all, One Macro to find them,
    One Macro to bring them all and to early bind them
    In the land of Microsoft where the Software lies

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Compilation of macros?

    <img src=/S/rofl.gif border=0 alt=rofl width=15 height=15> Brilliant, Hans! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>
    -John ... I float in liquid gardens
    UTC -7ąDS

  8. #8
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Compilation of macros?

    Pardon me for being a curmudgeon, but the Lounge includes a large collection of Macros, located via the Search Function!
    -John ... I float in liquid gardens
    UTC -7ąDS

  9. #9
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Cumberland, Maryland, USA
    Posts
    880
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compilation of macros?

    Exactly. A search in just a couple of forums shows numerous ones. I know there's no way of efficiently gathering and posting them. Anyway, it probably falls under "Why didn't I/we/someone think of that at the outset?" Maybe someone can arrange for a WOPR intern who can amass them--no pay, of course.

    My main point is that there are a number of very valuable micros spread throughout the Forum, and it would be of great use to members to have them compiled. Searching for a macro that relates to a specific issue is impossible; hence, my ill thought out musing is likewise impossible.

  10. #10
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Compilation of macros?

    My point is that if the macros were put into a central location, looking for one to fit a specific task would still be as much work as running a search on a Forum now. Many macros are custom designed to solve a unique problem, only a small precentage have kernels of reusable code.
    -John ... I float in liquid gardens
    UTC -7ąDS

  11. #11
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Cumberland, Maryland, USA
    Posts
    880
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compilation of macros?

    " . . .if the macros were put into a central location, looking for one to fit a specific task would still be as much work as running a search on a Forum now. "

    Yes, but if they were categorized and carefully labeled--obviously a humongous job--they'd be much quicker to find than running a general search, something more efficient than the 18,000+ Google hits for "Word Macros" or in the individual Forums. It's just an idea, obviously one that won't go anywhere.

  12. #12
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Hornsby Heights, New South Wales, Australia
    Posts
    3,822
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compilation of macros?

    Hi Dengar,

    I think it's a great idea. Trouble is finding someone to take on this task. You're welcome to do it and take the full credit for it at the end. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Cheers, Claude.

  13. #13
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Compilation of macros?

    Dennis, you probably won't be surprised to learn that this has been suggested before, though you might be amused to learn who suggested it: <post#=30999>post 30999</post#>.
    -John ... I float in liquid gardens
    UTC -7ąDS

  14. #14
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Cumberland, Maryland, USA
    Posts
    880
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compilation of macros?

    John, I AM surprised. Oh, well. I'm 3 years behind. Sorta deja vu all over again.

    The thread prompted by the post is informative and shows the complicated scope of such a project.

  15. #15
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Compilation of macros?

    Dennis, now that I have bewildered and amused you, I'll explain why my view on this idea changed (and these are just my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>, nothing more):

    1. In any forum many bits of code aren't highly reuseable (of course there are many valuable in-forum discussions on generically useful stuff, such as coding custom Toolbars; the VBA forum especially has a lot of generic discussions and cool API calls and shortcut code techniques, such as BrowseForFolder).

    2. Providing a directory of highly reusable code pieces is a great idea.

    3. Providing a directory of special use code would be difficult to index, and therefore as difficult to search as the Lounge itself, so why not leave it where it is.

    4. Often in code discussion, the lines of code develop through several posts in the thread, so final code isn't in one piece (that was what was frustrating me 3 years back, and the original reason I proposed a code library), making the threads difficult to search or index.

    5. When a Lounger learning VBA gets "over the hump" in learning enough about the Object model and most frequently used Properties and Methods, then that Lounger is better able to run more specific Searches on the Lounge, using the kinds of Objects, Methods and Properties that he/she is looking to work with. So it's one of those things where a little VBA knowledge makes a Lounger much more efficient in running Searches for code.

    You might want to talk to <!profile=ChrisGreaves>ChrisGreaves<!/profile> about his plan for world domination and Lounge code collection.

    You are reminding me that we should be Star Posting more of the reuseable code snippets.
    -John ... I float in liquid gardens
    UTC -7ąDS

Page 1 of 2 12 LastLast

Posting Permissions

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