Recent content by GHinCali

Tony: Nice little trick! I'll put it in my own bag of tricks! Thanks again. Gary

Tony: That was exactly what I needed! You saved me quite a bit of time and effort! Thank you. The only question I have concerns the calculation using the boolean variable, Carry. If Carry is True, is Carry = -1 always true? And if Carry is False, is Carry = 0 always true? I thought that a...

Skip; I am writing a testing program to test another program, which is the 'engine' for a financial analysis package. Part of the program I am writing adds records to a database (which could be a production database, so I do not want to touch live data) then exercises the 'engines' routines...

Thanks for the thought, Skip. Converting to ascii, creating ids, converting back, etc obviously could be done, but I think there must be a simpler method. Tony: I just started with A as the example, since that's the first column in Excel. The actual first id would be 0 as you suggest. I would...

I have a need for a routine to generate unique alphanumeric ids using the characters 0 thru 9 and A through Z as the basis, which are stored in a constant, sIDContents = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ". The resulting ids would be much like the column headers in Excel (i.e. A, B, C...

Is it possible to programatically remove or at least uncheck a component from the components list? I have a program that has some optional add-ins which the user can delete by deleting the XLS/XLA file. If this is done, after the XLS/XLA has been loaded in to the component list, Excel will...