Problem with import module

[Xsi]

Hello people,

I get this error when I trying to import a myBasfile.bas module.

here is my code

        Dim excelApp As Microsoft.Office.Interop.Excel.Application

        excelApp = New Microsoft.Office.Interop.Excel.Application
        excelApp.Visible = True
        excelApp.Workbooks.Add()
        Dim workingmodule As String
        Const vbext_ct_StdModule = 1
        excelApp.Visible = True

        workingmodule = excelApp.VBE.ActiveVBProject.VBComponents.Add(vbext_ct_StdModule).Name
        excelApp.VBE.ActiveVBProject.VBComponents.Item("Module1").CodeModule.AddFromString(My.Resources.MyBasfile)
        'excelApp.Run("Run_One")

Could someone help me?

Thank you in advance

 

[jebenson]

In your code you have "Module1" but in Excel it is named "Modul1" (no 'e').

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!