App-V 5.0 and AutoAudit 5.6.2.1

AutoAudit stores data in databases including documents of various formats including Word.  It also interoperates with Word with addins.  It took extensive testing of sequences to find a working configuration for the virtual application.  Word was installed locally in this case.

With App-V 5.0 SP2 sequences one type of word macro document would open correctly with one set of Advanced settings (Com and Named) but another type would not. Various SP2 settings could enable the macro functionality to work but no combination would enable ALL of the various macro documents to work.

Eventually it was discovered that an SP3 sequence without the COM and named advanced settings worked on both SP2 and SP3 clients.

AutoAudit note: the default settings can be set in the App-V package, however if you have Appsense you can just finish the sequence after the install and use Appsense Environment Manager to write the required default keys into the virtual registry. Personalisation can manage any addition settings or connections which the users adds.

Other complications arose from how the app handled its macro resource files AR13579.aot BD2468.aot  These files are copied by the application into the folder set in the application regkey WORD_TEMPLATES_FOLDER.  By default this value is set to the same value as HKCU\Software\Policies\Microsoft\office\14.0\common\general\UserTemplate

If this folder location is on a network location, say a home drive, then the folder must be listed in the trusted locations and AllowNetworkLocations must be on.  Consider using a policy location to avoid clashes occuring with user set locations settings.



[HKEY_CURRENT_USER\Software\VB and VBA Program Settings\AutoAudit\Primary]
"UserNameSQL"="hashed string"
"PasswordSQL"="hashed string"
"ServerNameSQL"="SERVERNAME"
"ClientRoleSQL"="ClientRole"
"DataBaseNameSQL"="DATABASENAME"
"DBType"="4"
"WORD_TEMPLATES_FOLDER"="C:\\SET\\TO\\VALID\\FOLDER\\FOR\\USER"
"WordExcelOpenPointLink"="0"
"WordOpenAuto"="0"
"GlobPath"="SERVERNAME\\\\\\DATABASENAME"


<The above keys may be written into the virtual registry for the user if possible.  They broadly define the default database connection.  The Word.... keys set audit setting preferences.>

<The below keys were written into the users real registry>

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Word\Security\Trusted Locations]
"AllowNetworkLocations"=dword:00000001

[HKEY_CURRENT_USER\Software\Policies\Microsoft\office\14.0\common\security\trusted locations\all applications\location5621]
"Path"="C:\\SET\\TO\\VALID\\FOLDER\\FOR\\USER"
"Description"="templates folder location for use with AutoAudit"