Writing Registry Fails from VBA in Vista (Word all

Topic

New Reply

This is a Vista question, but is specific to VBA, so I’m not sure where to post it…

I have an application that uses extensive reading/writing to the registry to store settings.

I do not use SetSetting/GetSetting (which write to the VBA Applications key) but System.PrivateProfileString writing the HKEY_CURRENT_USER.

I now have had two Vista users report the following error message:

run time error – 2147467259 (80004005)
Method ‘PrivateProfileString’ of object ‘System’ failed

Which would seem to indicate that the currently logged in profile does not have permission to modify the registry.

1) Have other VBA programmers run up against this?

2) Is there a simple way to have the user elevate their permissions in order to circumvent this problem?

Thanks for any pointers.

Reply | Quote

Replies

So, digging about a bit it seems that my application works as expected if the user either

1) runs Word “as administrator”

or

2) User Access Control has been turned off.

Is there a way to make writing to the registry more Vista acceptable, so that these measures are no longer necessary?

Reply | Quote

I don’t have Windows Vista, but I suspect that the only options are the two you mention, plus the user allowing access to the registry key(s) you use in RegEdit.

Reply | Quote

I’m not familiar with Vista Guy, but from what you say I’m guessing that several different users might use different settings on the one machine? If that’s the case, is there any mileage in using an .INI file for each user, in place of registry read/ writes?

Alan

Reply | Quote

Have you tried whether it does work using getsetting/savesetting?
Most of my downloads use it and I haven’t had complaints yet?

Reply | Quote