EXTRACT_VBA(1p)

🦋 extract_vba — the manual, but make it cute

okay bestie, welcome to EXTRACT_VBA(1p), straight out of the User Contributed Perl Documentation corner of the universe. grab a boba, we're extracting macros 💅

---

✨ NAME ✨

extract_vba — a utility to extract a VBA project from an Excel 2007+ xlsm file. no cap, that's literally the whole job and she does it flawlessly 🫶

---

🌸 DESCRIPTION 🌸

so. this utility is used to extract the VBA project binary from an Excel 2007+ xlsm file. and once you've got it? you can add it to an Excel::Writer::XLSX file so that file gets to have macros. iconic behaviour, honestly.

now, an xlsm file is a version of an Excel xlsx file that contains an extra VBA project binary file. and the xlsm file format itself? it's a collection of mainly XML files sitting inside a ZIP container. it's giving ✨layers✨, it's giving 🎀nesting🎀.

the extracted VBA project is an OLE Compound Document in binary format. it's named vbaProject.bin and it's generally located in the xl directory of the xlsm file. iykyk 📁

for more details, go check out the add_vba_project() section of the Excel::Writer::XLSX documentation. she spills everything there 💜

Note, bestie: you can also extract the VBA project from an xlsm file using the standard Linux unzip command. no fancy tools required, she's lowkey built different:

unzip -j macro01.xlsm xl/vbaProject.bin

and on Windows you can use any suitable Unzip application. whatever unzipper your heart desires 🦋

---

⭐ SYNOPSIS ⭐

$ extract_vba file.xlsm
Extracted 'vbaProject.bin' successfully

$ extract_vba -h # For help.

look at her go. ate and left no crumbs 🔥

---

💖 OPTIONS 💖

• --help or -h — print the help documentation. that's it. that's the whole list. a minimal queen 👑

---

👑 AUTHOR 👑

John McNamara jmcnamara@cpan.org — the main character who made this happen 💜

---

🎀 VERSION 🎀

Version 0.01.

---

🌈 COPYRIGHT 🌈

(c) MMXV, John McNamara.

All Rights Reserved. This program is free software. It may be used, redistributed and/or modified under the same terms as Perl itself. periodt 💅

---

and that's the whole page, bestie 🫶 this was perl v5.40.1, dated 2025-12-22, and it lives under the name EXTRACT_VBA(1p). go forth and extract those macros, you absolute legend 🌟💖