Search:

Type: Posts; User: bmilleridentco; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    7,768

    Hans, You are the man ! Works perfectly ! The...

    Hans,
    You are the man ! Works perfectly ! The one combination of quotes & & that I didn't try....haha.

    Thank you SIR !
    - BOB -



    Assuming that the QuoteNumber variable will contain a...
  2. Replies
    2
    Views
    7,768

    Hello I'm working on a script that has these...

    Hello
    I'm working on a script that has these two lines:

    Set ObjFSO=CreateObject("Scripting.FileSystemObject")
    objFSO.CopyFile "C:\med\quote\12345.xls", "C:\med\drop\Test.xls

    What I'm...
  3. Replies
    3
    Views
    408

    If you want to be able to use 5 digit numbers,...

    If you want to be able to use 5 digit numbers, shouldn't you have entered 00001 in G2 instead of 0001, so that you get 00001, 01000 etc.?

    Thanks Hans,
    Wow...can't believe you read this...
  4. Replies
    3
    Views
    408

    Hello, I'm trying to solve an issue with...

    Hello,
    I'm trying to solve an issue with formatting numbers on a spreadsheet that is creating serial numbers. I have attached a screen shot to begin with. The number of digits to format the...
  5. Re: Alphanumeric Serial numbers (Excel 2003)

    Thanks Hans !
    That wasn't as compliated as I thought.. :-)
  6. Alphanumeric Serial numbers (Excel 2003)

    I'm looking for a formula for calcuating the number of possible combinations in a serial number of "x" number of digits using an "x" base number. For example, if I have a 6 digit serial number...
  7. Re: Excel & different numbering systems (2003)

    Hi Hans,
    I tried this version and it works to calculate the starting and ending # of each roll just fine as long as the number is base 10. I didn't see it calculate anything when I tried a...
  8. Re: Excel & different numbering systems (2003)

    You're correct, that's the post I'm refering to. I can increment the value by changing the "+1+" to other another value. I'm trying to create a "schedule" of numbers for each roll of labels to be...
  9. Re: Excel & different numbering systems (2003)

    Hi Hans,
    Thanks for the reply. I was able to use the formula you created last year. I can get the first line to work but then when trying to calculate the second line, the formula bombs out...
  10. Excel & different numbering systems (2003)

    I'm looking to be able to produce a spreadsheet that can calculate serial numbers in different numbering systems i.e. base33, base34, base36 etc.. These numbers would then be printed on rolls of...
  11. Replies
    9
    Views
    583

    Re: Clear locked files (2000 SR1a)

    Haha....good to see that you are still out there....I didn't realize how old your original reply was when I responded.

    Have a good day !
    - BOB -
  12. Replies
    9
    Views
    583

    Re: Clear locked files (2000 SR1a)

    Hi Paul,
    Your suggestion may not have been the exact fix for David but it did help me as I was having the very same issue. The Admin tools path is what worked for me so thanks very much ! ...
  13. Replies
    4
    Views
    2,209

    Re: Permissions deleted

    Wow....thanks for the quick reply...that's why I like this board.

    That did the trick. It was showing me a message about taking ownership but I didn't know how to get there.

    Thanks again Joe !...
  14. Replies
    4
    Views
    2,209

    Permissions deleted

    Hello,
    Yesterday, I went to open a folder on our network and was denied access. Thought that was unusual since I have administrator rights. If I right-click on the folder and look at the...
  15. Outlook 2003 and missing reply text (11.6568.6568 SP2)

    We have an unusal problem with two Outlook users. Each will reply to a multi-address email using Reply All. The recipents, when viewing the reply, only see the signature block and none of the text...
  16. Re: Serialized alphanumeric formula (Excell 2003)

    Hi Jerry,
    Thanks for taking the time to look at my issue. I need to clarify as I may have misused the term Base33. We print serialized barcode labels and usually a sequence used 0-9 so 0001,...
  17. Serialized alphanumeric formula (Excell 2003)

    Hello,
    Does anyone know of a formula that can be used to calculate beginning and ending numbers in a Base 33 alphanumeric sequence ? The letters left out of the sequence are I, O, and S. I...
  18. Re: Creating a 'roll schedule' (2003, SP2)

    Hi Legare,
    Yes...that would work very well for an 8 digit serial number sequence......thank you for taking the time to work on this !

    - BOB -
  19. Re: Creating a 'roll schedule' (2003, SP2)

    Hi Steve,
    thanks for the reply. I should have been more specific in my original post. A serial number sequence can vary from 3 digits to 8 digits and more of our customers are using...
  20. Re: Creating a 'roll schedule' (2003, SP2)

    Hi Steve,
    One more question if you don't mind...
    Can this be modified if the serial number is larger than 5 digits and still be able to show the leading zeros ? We do get some serial...
  21. Re: Creating a 'roll schedule' (2003, SP2)

    Wow Steve...that does exactly what I was trying to do......I can't thank you enough !

    Users here at Woody's are the best ! !

    - BOB -
  22. Creating a 'roll schedule' (2003, SP2)

    Hello all,
    I'm working on creating what's called a "roll schedule". We use it for printing serialized labels. This makes it easy for the person doing the printing. Here's an example: we will...
Results 1 to 22 of 22