[sims] Individual Reports problem

[caffrey]

Having a mare with macros

 

I've noticed though instead of saving the temp file into C:\Users\[Your Username]\Documents\tempSimsRpt which is a trusted location, the file is actually saved in c:\Users\[Your Username]\AppData\Local\Temp which of course is untrusted - where do I set environment variables ?

[caffrey]

Got to the bottom of it, but not fixed - It's Windows Defender stopping it as it's trying to run from Appdata\local\temp\

 

Windows Defender Antivirus has blocked an operation that is not allowed by your IT administrator.
For more information please contact your IT administrator.
	ID: 92E97FA1-2EDF-4476-BDD6-9DD0B4DDDC7B
	Detection time: 2019-11-07T10:52:03.614Z
	User: THS\username
	Path: C:\Users\username\AppData\Local\Temp\IndRepBaseTemplate.dot
	Process Name: C:\Program Files (x86)\Microsoft Office\Office16\WINWORD.EXE
	Signature Version: 1.305.1588.0
	Engine Version: 1.1.16500.1
	Product Version: 4.18.1807.18075

[SpreadsheetJockey]

We recently solved a problem with individual reports refusing to run, by installing Windows Security Update KB3039734 which was missing for some reason - just in case you are having a similar issue.

[caffrey]

Running 2016 here though, and that KB won't install

[SpreadsheetJockey]

I think the 2016 version might be KB3085538, or possibly KB4475554, which was published quite recently. Edited November 7, 2019 by SpreadsheetJockey

[caffrey]

No dice, only way to get these things running is allow access to the temp directory which would make the AV pointless... - tried some exclusion rules to no avail either

[caffrey]

Got it in the end,

 

Had to do a file exclusion rule which for some reason I couldn't get working with environment variables but I'll experiment with that later

I had to put the full path to the file e.g. C:\Users\username\AppData\Local\Temp\IndRepBaseTemplate.dot - means I'll need to do an exclusion for each user but we only really have one person on site who does the individual reports so that'll do for now