How to Convert Access Macro to Visual Basic

In Microsoft Office's Access program, a macro is an action or set of actions that may be used to automate specific tasks. Visual Basic is an event-driven programming language which allows the rapid application development (RAD) of various graphical user interface (GUI) applications, access to a range of databases,and creation of ActiveX objects and controls. Converting an Access Macro file to Visual Basic is very simple and does not require any program except Microsoft Access itself.

Instructions

1. Start the Microsoft Office Access program. Go to "File," then "Open." Select a Access Macro file to convert. Click "Open."

2. Select "Macros" in the database window under "Objects."

3. Click "File" in the top menu. Click "Save as." Select "Module" in the "Save As" field. Click "OK."

4. Click on the "Add Error Handling to Generated Functions" and "Include Macro Comments" check-boxes in the "Convert Macro" window.

5. Click "Convert."

References

• Microsoft Office Online
• Microsoft Support