How to create a macro by vba script?

志安 陈 1 Reputation point
2020-11-28T12:28:14.097+00:00

Hi:
I am going to write a tool using vba which can check a vba code that was converted from a MS-Access macro.But there is not any available API to get the final code in Object "CurrentProject.AllMacros('macro-name')" or "CurrentProject.AllModules('converted-module-name')".

How to create a macro by vba script?
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,768 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Dave Patrick 426K Reputation points MVP
    2020-11-28T12:37:11.483+00:00

    Access is not currently supported here on QnA. They're actively answering questions in dedicated forums here.
    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access
    https://social.msdn.microsoft.com/Forums/en-US/home?forum=accessdev

    --please don't forget to Accept as answer if the reply is helpful--

    0 comments No comments