+ Reply to Thread
Results 1 to 5 of 5

Post code vs. attach woirkbook

  1. #1
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Post code vs. attach woirkbook

    Hi,

    I would like to get the thoughts of advantages/ disadvantages regarding the VBA part of this forum. More and more I find users answering questions by attaching a workbook as a solution but not showing the code. I can understand that itīs a very good means to any new user finding the code and maybe a button with the solution.

    But as I regard myself as being a slightly advanced user in VBA I find it unnecessary to download a "solution" workbook to have to state when seeing the code used that a) the solution isnīt referring to the way my problem is laid down and b) a macro-recorder code has been used more or less and has been modified a bit (this can be fine, nothing against the recorder - I started learning VBA by the use of it and still use it but usually rework the code to avoid all the Selections, and okay, I may have read a book or two about the subject as well and maybe even adapted some habits from them). I donīt mind the traffic for my provider but the forum software maybe has a bit more of traffic to do then it would need to have.

    A good argument for me doing both is that the search for the board can only update the index on terms found in the text or the code segments delivered (please correct me if Iīm wrnog - it was at least with Version 3.5...). This doesnīt mean that the search in ths forum satisfies me in what I search for (I usually take an external search for far better results in what I really search) but I think we could as least try to support it.

    Awaiting your thoughts on this (come on, tell me Iīm wrong and I should mind my own business and not download other peopleīs attachments ).

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Post code vs. attach woirkbook

    I reckon it does depend on the question, the answer and the knowledge of the guy/gal asking the question but mostly I would post the code maybe with a workbook too
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Post code vs. attach woirkbook

    If it's just a code solution that can be copied and pasted, I'd probably just show the code, no workbook. If it needs other components, like named ranges, I might upload the updated sample workbook.

    Regards,TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Post code vs. attach woirkbook

    I mostly paste the code only, but if the user is finding it difficult to follow what goes where, then i attach a workbook.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  5. #5
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Post code vs. attach woirkbook

    Hi,

    thanks for sharing our thoughts, basicly itīs the same idea I would state as none of those who have answered so far just mentioned to only attach a workbook without showing the code.

    Iīm really sorry for the typo in the thread title - I hate looking at the preview and not to see them in order to remove them (they only come out after having pressed submit I guess ).

    Ciao,
    Holger

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1