Extract and Deobfuscate XLM macros (a.k.a Excel 4.0 Macros)
-
Updated
May 5, 2024 - Python
Extract and Deobfuscate XLM macros (a.k.a Excel 4.0 Macros)
Financial Statement Generator
Automatically create personalized tables of assignments for each employee, allowing them to focus on only their assignments and priorities.
Weekly B2B purchase orders arrive as PDFs in different vendor layouts. This automates extraction, cross-validates quantity × price against each vendor's stated total, and feeds the clean data into an Excel macro for downstream processing. Built after noticing an AI-based PDF scan step occasionally misread vendor documents in my actual job.
Boilerplate for macro Excel to load text file.
Excel equidistant background coloring using the golden ratio and VBA.
Utilize VBA scripting to analyze real stock market data for 3 consecutive years (2018 - 2020).
VBA function for Arabic numbers-to-words conversion. Supports Long Scale (Europe), 3 styles (Modern, Classic, Sastra), and advanced Arabic grammar (Ism Manqus, I'rab, Gender).
My favourite Excel macros - some by me, some by others
TerbilangID adalah fungsi VBA (Visual Basic for Applications) untuk Microsoft Excel yang mengubah angka menjadi teks terbilang dalam Bahasa Indonesia secara akurat dan fleksibel. The ultimate Indonesian number-to-words converter for Excel.
A multi-step Excel VBA macro pipeline that automates the weekly order-processing workflow for a pharmaceutical import/export operation. Originally built to replace a fully manual process of transcribing purchase orders into a production-request format.
VBA Excel macro that reads excel workbook containing stock data, (each worksheet containing one year's data) and outputs required information.
To associate your repository with the excel-macro topic, visit your repo's landing page and select "manage topics."