Registry problem with VBA

Question

Hi everybody,

I have an Excel Macro for writing values to the registry. It works fine in Excel 2007, but with Excel 2010 the registry does

not change and I don't get any errory message. Here is the code:

Sub Test()    RegKeySave "HKEY_CURRENT_USER\foo\bar", Now, "REG_SZ" End Sub Sub RegKeySave(i_RegKey, i_Value, i_Type)    CreateObject("WScript.Shell").RegWrite i_RegKey, i_Value, i_Type End Sub

Any ideas ?

Thanks in advance !

Regards 

Markus

---

Answer 1

Just for reference your original code writes to the registry here using 32bit Excel 2010 and 32 bit Windows 7 Ultimate.

---

John Wilson PowerPoint MVP PowerPoint Alchemy

Answer 2

Hi Tushar,

Thanks for your answer.

I've just tried out SaveSetting, but I'am still getting the same result: in Excel 2007 it works, but not in Excel 2010 !

Regards Markus

Answer 3

In VBA whenever I've wanted to save something in the registry I've used the VB functions: SaveSetting, GetSetting, DeleteSetting, and GetAllSettings.

Might be something you want to explore.

---

Tushar Mehta (Technology and Operations Consulting)

www.tushar-mehta.com (Excel and PowerPoint add-ins and tutorials)

Microsoft MVP Excel 2000-Present

Answer 4

Hi there,

thanks for your answer. I have Windows 7 and Office both on 32-bits !

Regards Markus

Answer 5

Could this be a 32bit versus 64bit issue? If your Windows 7 installation is 64-bit and your Office installation is 32-bits, the key needs to be written somewhere inside the WOW64 section of the registry.