Converting VBA to Macro (1 Viewer)

Kundan

Registered User.
Local time
Today, 08:39
Joined
Mar 23, 2019
Messages
118
How to convert a VBA code to a Macro. Is there any built in facility?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 08:39
Joined
Oct 29, 2018
Messages
21,360
No built in facility to go this way because vba can do more than macros.
 

plog

Banishment Pending
Local time
Today, 10:39
Joined
May 11, 2011
Messages
11,613
Give us the big picture of what you are trying to do. As Dbguy said, this is unusual--VBA is more powerful and works in more situations than macros.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 08:39
Joined
Oct 29, 2018
Messages
21,360
My guess is it might have something to do with the other thread were macros work in accde, but VBA doesn't.
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 15:39
Joined
Jul 9, 2003
Messages
16,245
WTF? It's too early in the morning! I just seen, the Question is the other way round!

Oops!
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 15:39
Joined
Jul 9, 2003
Messages
16,245
In my own defence, I've never heard that question asked before!
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 10:39
Joined
Feb 28, 2001
Messages
27,005
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.
 

onur_can

Active member
Local time
Today, 08:39
Joined
Oct 4, 2015
Messages
180
Hello friends,
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.
 

Users who are viewing this thread

Top Bottom