Change a registry value with vba

[Michael57]

I would like to use vba code to change the following registry value which is currently "0" to "QuoteNo"

HKEY_CURRENT_USER\Software\Adobe\Acrobat PDFWriter\PDFFileNameSet

Can anyone help? Thanks in advance.

 

[jrbarnett]

http://support.microsoft.com/kb/145679

John

 

[TonyJollans]

Slightly simpler ...

[blue]System.PrivateProfileString("","HKEY_CURRENT_USER\Software\Adobe\Acrobat PDFWriter","PDFFileNameSet") = "QuoteNo"[/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[Michael57]

When I try putting
System.PrivateProfileString("","HKEY_CURRENT_USER\Software\Adobe\Acrobat PDFWriter","PDFFileNameSet") = "QuoteNo" in my code it gives Runtime Error 424 Object required
Any tips?

 

[TonyJollans]

You're not using Word, then? I guess you're stuck with the API in other apps, unless you want to instantiate Word which is probably over the top

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[PHV]

And what about this ?
CreateObject("WScript.Shell").RegWrite "HKCU\Software\Adobe\Acrobat PDFWriter\PDFFileNameSet", "QuoteNo", "REG_SZ"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886