Forum Discussion
Gilgamesh1964
Nov 15, 2021Brass Contributor
VBA - How do I determine if a roaming profile is being used?
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.
No RepliesBe the first to reply