I'm curious as why you are using Word to write to the Registry, if this code
is in Excel.
If VBA Savesetting cannot save to the correct key, the API versions
certainly can.

NickHK

"dai50" wrote in message
...

I'm using a Word object to write information to the registry from within
an Excel Macro (this is in order to generate a PDF file using CutePDF).
Everything works fine but the Winword object is still resident in
memory.

The code is as follows:

Function SetRegKeys(Section as String, Key as String, KeyValue) as
Boolean
Dim wrd As Word.Application
SetRegistrySetting = False
Set wrd = New Word.Application
On Error Resume Next
wrd.System.PrivateProfileString("", Section, Key) = CStr(KeyValue)
On Error GoTo 0
Set wrd = Nothing
SetRegistrySetting = True
End Function

It's probably self evident but I should add that I am no VBA expert.

Thanks


--
dai50
------------------------------------------------------------------------
dai50's Profile:
http://www.excelforum.com/member.php...o&userid=32741
View this thread: http://www.excelforum.com/showthread...hreadid=556470