[dba-Tech] Excel procedure

Came across this, this morning in Rod Stephens newsletter
might help

1. New HowTo: Use VBA to generate code to reproduce basic calcualtions 
on an Excel worksheet
http://www.vb-helper.com/howto_vba_excel_formulas.html
http://www.vb-helper.com/HowTo/howto_vba_excel_formulas.zip

The example code performs three tasks:

    1. Identify the cells that need calculation
    2. Put the cells in a valid execution order
    3. Generate VBA code to evaluate the cells' values



Susan Harkins wrote:

>Anyone have a procedure that adds a value to an existing value upon opening
>the workbook? Don't anybody create anything -- a reader is trying to
>increment an invoice number and this seems the easiest solution to me -- if
>anybody's got a generic procedure I could send, would be great -- if not,
>delete and read on. ;) 
> 
>Susan H. 
>  
>
-- 
Marty Connelly
Victoria, B.C.
Canada