Tutorial on VBA architecture and project structure needed

Hi there, anyone knows a good tutorial on the VBA architecture and project structure? I would need more info on .xlam vs. .xlsb vs. and other project structures that are VBA and or Excel specific.

Thanks a lot!
Sven