VisualRATEX AvMacro.xlsm & pscp.exe (KB111)


When a VR report is exported to Excel, pscp (open source utility bundled with Putty) is called to securely copy (scp) the raw report data (a delineated text file) from the VR server to a user’s desktop as C:\Ratex_Print_Data\excel.txt.  This is then built into excel format using avmacro and the appropriate template, in C:\Ratex_Templates.  We host them in the KB for users to deploy it on older systems that don't have it.