Nov 14 2021 10:32 PM
Hello,
I need to update the OfficeUI files from within VBA.
I already have the code to do the modifications and I can easily find the files to update from %LocalAppData%\Microsoft\Office\*.officeUI.
However that is only for a local profile, I want to cater for if a roaming profile is used. Again, the location is easy - %AppData%\Microsoft\Office\*.officeUI
My question is - From within VBA how do I determine if a roaming profile is being used so I can choose the right files to update?
My fall-back (if necessary) is to check for the officeUI file in both locations and update both, but I would prefer to be smarter about it.
Thanks in advance.