Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Fri Apr 20 08:06:46 CDT 2007
Susan: I don't know the code but I would turn on the macro recorder, record the keystrokes and then look at the code it generated, and use it in the open event of the workbook. That's how I usually make code in Excel. Rocky -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Friday, April 20, 2007 5:19 AM To: 'Discussion of Hardware and Software issues' Subject: [dba-Tech] Excel procedure 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. _______________________________________________ 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.5.5/769 - Release Date: 4/19/2007 5:56 PM