Kundan, the problem with converting VBA code to a Macro is that the things a Macro can do are more limited than the things that VBA can do, so it becomes a real problem to do the conversion. Not everything you can do in VBA is even possible in a Macro.
Can you perhaps tell us WHY you want this? Then we might be able to advise you better.
You can convert a macro to VBA code. But as our plog friend said, VBA is from macros
is much more powerful. I want to talk about an issue in Access's definition. MS Access offers you a number of wizards for programming,
You write in a database with the help of wizards, almost without writing code. Likewise, you just write a simple database using only macros.
So what do you do when things get a little more complicated?
Of course, it is time to take advantage of the power of VBA.
As a result, you must master VBA and SQL language beyond Macros and Wizards to gain full control of Access.