naming convention

  1. J

    Copy Hidden Template - Results in Error

    Hi - I have a code (shown below) that is creating multiple copies of a template worksheet and number sequentially. The problem is that I would like to have the template worksheets hidden, but when I do this I get a Run Time Error 1004: Method Select of Object_Worksheet failed. If not hidden, it...
  2. O

    Special characters in procedures and variables: MySub§() ¿testSub() CopyrightSub©() Range¤ ...

    I know we all have our way of naming functions, subs and variables. But why don't we use special characters in the procedure-names? Like: MyFunctionName§() or MyCopyrightSub©() or even ¿test_MyFunctionName() It has his advantages! Procedures starting with one can be alphabetical above...
  3. T

    Sequential Invoice...with a twist.

    Hi. Hope your day is great. Wondering if you could help me with the following: I think it may be easy for you (but very appreciated by me!): I have maybe 25 invoices in one folder, depending on what item the customer orders, and the invoice # is always in the same cell. What I need is a macro...
  4. R

    FSO When Naming Conventions are Inconsistant

    I've got a folder full of drawings, over 70,000 of them. They are all drawings in PDF format with the part number as the name. Sometimes. There are half a dozen different ways the files are stored, all with the first 7 chars being the part number, say 12345678.pdf Many of the files do not...
  5. ClimoC

    I want to show this off

    Just because I think in an office environment this kind of thing is really crafty and cool. based on a simple naming convention, you can dynamically move around macros within your company. Example: 1.Setup (under the Baddress\role macros) folders called 'TIM1' 'BOB2' & 'ALEX' 2.Name your...

Some videos you may like

This Week's Hot Topics

Top