Store Macro through C#

Question

I wanted to write a macro and run it from C#. The following is the code. Microsoft.Vbe.Interop.VBProject vbp = new Microsoft.Vbe.Interop.VBProject(); Microsoft.Vbe.Interop.VBComponent vbc = vbp.VBComponents.Add(Microsoft.Vbe.Interop.vbext_ComponentType.vbext_ct_StdModule); StringBuilder sb = new StringBuilder(); sb.Append(Sub FormatSheet() + 
); sb.Append( Selection.Find.Text= 'A-Gen' + 
); sb.Append( Selection.Find.Execute(ref fndtext ref missing ref missing ref missing ref missing ref missing ref missing ref missing ref missing ref missing ref missing ref missing ref missing ref missing ref missing) + 
); sb.Append( Selection.Range.Paragraphs.OutlineLevel = Microsoft.Office.Interop.Word.WdOutlineLevel.wdOutlineLevel1); sb.Append(End Sub); string sCode = sb.ToString(); vbc.CodeModule.AddFromString(sCode); But it shows the error as {Retrieving the COM class factory for component with CLSID {0002E169-0000-0000-C000-000000000046} failed due to the following error: 80040154.} Thanks in advance for any help!

chenthilvela · Answer

I have done reference's as Microsoft.Vbe.Interop and its not showing any build error. But while running the following line Microsoft.Vbe.Interop.VBProject vbp = new Microsoft.Vbe.Interop.VBProject(); is showing the error as .... {Retrieving the COM class factory for component with CLSID {0002E169-0000-0000-C000-000000000046} failed due to the following error: 80040154.} guide me how to resolve the reference problem.... Thanks in advance for any help!

Sam Hobbs · Answer

Are you sure that the VBProject and VBComponent objects were created successfuly? Probably not. You are probably not creating a VBProject object that can be used in the manner you need it to be used.