Menu
I was provided an add-in for powerpoint as a .ppam file and another add-in for Excel as .xslm file. The add-in's work great, but I would like to customize them with some internal requirements.
My questions is - how to open the source code behind a .ppam file ( which I understand is a compiled version) to be able to perform the customizations.
702
If it's a PPAM file, it was created in PowerPoint from a PPTM file saved as an add-in. While you can edit loaded add-ins "in place" for testing purposes, you can't edit then save them. But you can export the add-in's modules then import them into a new PPTM file or copy/paste code between the two.
You can open PPAM files with Microsoft PowerPoint 2007 or later in Windows and macOS. To open a PPAM file with PowerPoint 365, select File → Open → Browse, then choose "PowerPoint Add-ins (*. ppam;*. ppa)" from the format dropdown menu.
Create the add-in projectUsing the search box, enter add-in. Choose PowerPoint Web Add-in, then select Next. Name your project and select Create. In the Create Office Add-in dialog window, choose Add new functionalities to PowerPoint, and then choose Finish to create the project.
If it's a PPAM file, it was created in PowerPoint from a PPTM file saved as an add-in.
While you can edit loaded add-ins "in place" for testing purposes, you can't edit then save them. But you can export the add-in's modules then import them into a new PPTM file or copy/paste code between the two.
In order to get access to the modules/code of the loaded add-in, you need to make a registry change.
IMPORTANT: Quit PowerPoint first.
Then go to:
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\PowerPoint\Options
(That'd be for PPT 2010; substitute 16.0 in place of 14.0 for PPT 2016/365 and PPT 2019, 15.0 for PPT 2013, 12.0 for PPT 2007 and so on ... there's no 13.0)
Add a new DWORD value: DebugAddins = 1
Start PPT again; now your loaded add-ins will appear in the VBA IDE. If they're not password protected, you'll be able to open them, edit for test purposes, and export the modules or copy/paste for use in a new PPTM file.
Be sure to export any modules you've changed fairly often; if you quit PPT or it crashes, you'll lose any changes since the last save.
64
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
