c# read/edit accdb macro

Question

I am trying to access the macros inside of an Access database (accdb).

I tried using:

using Microsoft.Office.Interop.Access.Dao;

...

DBEngine dbe = new DBEngine();
Database ac = dbe.OpenDatabase(fileName);

I found a container["Scripts"] that had a document["Macro1"] which is my target. I am struggling to access the contents of the document. I also question if the Microsoft.Office.Interop.Access.Dao is the best reference for what I am trying to achieve.

What is the best way to view the content of the macros and modules?

Answer 1

You can skip the DAO part, it's not needed in this case. Macros are project specific, so in order to get them all, you would need to loop through your projects. In my example, i just have one project.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Microsoft.Office.Interop.Access;

namespace Sandbox48
{
    public class Program
    {
        public static void Main(string[] args)
        {

            Microsoft.Office.Interop.Access.Application oAccess = null;
            string savePath = @"C:\macros\";
            oAccess = new Microsoft.Office.Interop.Access.Application();

            // Open a database in exclusive mode:
            oAccess.OpenCurrentDatabase(
               @"", //filepath
               true //Exclusive
               );

            var allMacros = oAccess.CurrentProject.AllMacros;

            foreach(var macro in allMacros)
            {
                var fullMacro = (AccessObject)macro;
                Console.WriteLine(fullMacro.Name);

                oAccess.SaveAsText(AcObjectType.acMacro, fullMacro.FullName, $"{savePath}{ fullMacro.Name}.txt");
            }
            Console.Read();
        }
    }
}