Susan Harkins
ssharkins at setel.com
Fri Apr 20 09:23:24 CDT 2007
Well, you're right about that -- I hadn't considered that -- good point. Susan H. 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!" _______________________________________________ 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