excel addin on win7 - program files access issues

[dantheman9]

Hi,
Im aware that it is not the best practice to wirte into program file folders, but at the moment I'm not sure how i could work around it.
Basicly I have a html file which is installed with my addin into this location.
within my vba marco, this file is opened and edited to add more information. However with win7, access to open the file to edit is denied.
how could i work around this?
If I installed the addin folder to 'C:\' would this get around the issue? or is root also closed access?
from googling i have found that appdata (for win7) add application data folders might be a good place for the html file to go, but then how could i get my vba code to file the file path via the correct user?

thanks for any help on this

 

[Ralajer]

If you decided to go with the appdata folder route you can access that directory location via Environ("appdata"). This return the appdata folder for the logged in user. On my computer Environ("appdata") = "C:\Users\Rob\AppData\Roaming"