Saving

When you record a new macro there are a couple of places you can store it. These will depend on the Microsoft Office application you are using.
This is a common question and there is not really one answer that fits all situations.
An important factor though is whether you want anyone else to have access to your macros.


Excel - Personal.xlsm

For more details about the Personal.xls workbook, refer to the Excel > Macros > Personal.xlsb page.
If the functionality is to be shared by several users, you should consider creating an Excel Add-in.


Excel - Add-in.xlam

Excel add-ins can be either .xla or xll
A VBA add-in is a file which can provide additional functionality to a Microsoft Office application.
You should always recompile your code before saving your file as an addin.
These are ideal for distributing custom worksheet functions.
For details about how to create Excel add-ins refer to Excel > Add-ins.
For more details about how to install an Excel add-in, refer to the Excel > Add-ins > Installing page.
For more details about how to remove an Excel add-in, refer to the Excel > Add-ins > Removing page.
For more details about how to remove an Excel add-in, refer to the Excel > Add-ins > Replacing page.


Word - Normal.dotm

For more details about the Normal template, please refer to the Word > Templates > Normal.dot page under Word.
If the functionality is to be shared by several users, you should consider creating a Word Add-in or using a Global Template.


Word - Add-in.dotm

Word add-ins can be either .dot or wll.
For more details about how to install an Word add-in, refer to the Word > Add-ins > Installing page.


PowerPoint - Add-in.potm

For more details about how to install an PowerPoint add-in, refer to the PowerPoint > Add-ins > Installing page.


Outlook - VBAProject.otm



© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext