Aspose.Cells.Examples.CSharp.Articles.ManagingVBAModules.AddLibraryReferenceToVbaProject.Run C# (CSharp) Method

Run() public static method

public static Run ( ) : void
return void
        public static void Run()
        {
            // ExStart:1
            string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
            string outputPath = dataDir + "Output_out.xlsm";

            Workbook workbook = new Workbook();

            VbaProject vbaProj = workbook.VbaProject;

            vbaProj.References.AddRegisteredReference("stdole", "*\\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\\Windows\\system32\\stdole2.tlb#OLE Automation");
            vbaProj.References.AddRegisteredReference("Office", "*\\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.0#0#C:\\Program Files\\Common Files\\Microsoft Shared\\OFFICE14\\MSO.DLL#Microsoft Office 14.0 Object Library");

            workbook.Save(outputPath);
            // ExEnd:1
            Console.WriteLine("\nProcess completed successfully.\nFile saved at " + outputPath);
        }
    }
AddLibraryReferenceToVbaProject