[dba-Tech] Excel procedure

On 4/20/07, Susan Harkins <ssharkins at setel.com> wrote:
> Not sure that would work in this case. I'm thinking it should be a simple
> matter to simply add 1 to an existing value, but I don't work with Excel. ;)

Wouldn't recommend doing it automagically. Think about it this way, if
they just opened the invoice to look at it, it would increment the
number.

At first glance, and after being at the dentist and then going and
having blood work done, I would create a template, and in the AutoNew
increment the number that way, but then the number would have to be
written out to a text file, to keep track ofthe last number. I don't
think that Excel can manipulate the template that you are creating a
new spreadsheet from while you are creating the spreadsheet. But
that's just a gut feeling and not based in fact.

But if they did want to increment it in the auto open, here's how you
would do it (air code, may need to be checked for syntax validity)

Activesheet.cells(1,1) = Activesheet.cells(1,1) + 1

-- 
Bryan Carbonnell - carbonnb at gmail.com
Life's journey is not to arrive at the grave safely in a well
preserved body, but rather to skid in sideways, totally worn out,
shouting "What a great ride!"