Is everything done with VBA doable with Macro or vise versa?
No. VBA is FAR more powerful and versatile than using a Macro. Access allows you to convert Macros to VBA but does not have the corresponding reverse button to convert VBA to Macros. It is EASILY possible to do things in VBA that could NEVER be done correctly by a Macro.
To be fair, there IS a place for beginners to use Macros - e.g. if you have a sequence of queries that need to be run in order, you could easily do that with a Macro. But if you had to test something complex about the queries after each macro step to verify that each one ran correctly, you are stepping outside of the range of Macro abilities.
My understanding is Macro modules are there to make things easier if I don't wanna use VBA.
Yes and no. Where there is a Macro action corresponding to what you want to do, yes it is easier and should work perfectly well. But as I described above, in some cases there IS no corresponding Macro action and VBA becomes your only available method.
Macros tend to be limited on making complex decisions and on error handling. Macros tend to be of limited usability for essentially linear steps. Oh, you CAN do some logic solely using a Macro - but like I said, limited when compared to VBA.