How to write to Registry

jgoulart · Mar 17th, 2002, 10:02 AM

I have an invoice program that I want to keep track of the current invoice number and update that sequentially. Can I write the current invoice number to the registry and if so, how do I do that?

John

Mark O'Brien · Mar 17th, 2002, 10:13 AM

You can use "SaveSetting" and "GetSetting" just so long as you don'y really care what part of the registry you're writing to. I believe that this writes to a VBA directory of the registry.

Anyway, the help file's got a good example there and it should help you.

Ivan F Moala · Mar 17th, 2002, 09:42 PM

You could also create your own
Text file or ini file and just refernce this
via sequential line input

Look up Input in the VBE

Ivan

Juan Pablo González · Mar 18th, 2002, 09:39 PM

Another option
Use some API calls to access the whole registry. If you need them, repost.

Dave Hawley · Mar 18th, 2002, 09:50 PM

Hi jgoulart

I have a free downlod here that maybe of interest to you: http://www.ozgrid.com/download/default.htm
It's under:
InvoiceAutoNumber.zip

Mar 17th, 2002, 10:13 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	You can use "SaveSetting" and "GetSetting" just so long as you don'y really care what part of the registry you're writing to. I believe that this writes to a VBA directory of the registry. Anyway, the help file's got a good example there and it should help you. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Mar 18th, 2002, 09:39 PM	#4
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Another option Use some API calls to access the whole registry. If you need them, repost. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 17th, 2002, 10:02 AM	#1
jgoulart Board Regular Join Date: Feb 2002 Location: John G Posts: 62	I have an invoice program that I want to keep track of the current invoice number and update that sequentially. Can I write the current invoice number to the registry and if so, how do I do that? John

Mar 17th, 2002, 09:42 PM	#3
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	You could also create your own Text file or ini file and just refernce this via sequential line input Look up Input in the VBE Ivan

Mar 18th, 2002, 09:50 PM	#5
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi jgoulart I have a free downlod here that maybe of interest to you: http://www.ozgrid.com/download/default.htm It's under: InvoiceAutoNumber.zip