Changing a registry key using a vba macro 1

[Chrissirhc]

Hello,

How can I change a registry key using an Excel VBA macro?

I wanted to put this code in auto_open so that the registry has correct information for the sheet to function.

Thanks in advance,

Chris

 

[Chrissirhc]

Ok one last question... Sorry...

Why is it that RegOpenKeyA returns a success code when I've deleted the key in question from the registry???

Furthermore, there is a phkResult...

 

[Chrissirhc]

Sorry to bump this... Does anyone know the answer?? What is the Author thinking?

Thanks,

Chris

 

[Chrissirhc]

Why is it that RegOpenKeyA returns a success code when I've deleted the key in question from the registry???

What situation is the author trying to catch?

 

[KenPuls]

Sorry, Chris,

I've been away for a few days. To be honest, I've never really tried to analyze this routine. When I first used it, it was so over my head, and I've never gone back to look at the guts of it again. I'll try and take a peak a bit later and see if I can shed any light...

Ken Puls, CMA

http://www.excelguru.ca