[dba-Tech] Excel procedure

Thanks Marty!

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: Saturday, April 21, 2007 1:38 PM
To: Discussion of Hardware and Software issues
Subject: Re: [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

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 269.4.0/762 - Release Date: 4/15/2007
4:22 PM