[dba-Tech] Excel procedure

Susan Harkins ssharkins at setel.com
Fri Apr 20 08:43:58 CDT 2007


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. ;)


Susan H.  

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Friday, April 20, 2007 9:07 AM
To: 'Discussion of Hardware and Software issues'
Subject: Re: [dba-Tech] Excel procedure

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
 

_______________________________________________
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
 




More information about the dba-Tech mailing list