VB.NET SaveAs coding result with debug error

[m4_prashanth]

Hi there,

I was trying to edit a excel document and save under different name and my coding for this is as follows.

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click


        'Open
        Dim MyExcel As New Excel.Application
        MyExcel.Workbooks.Open("C:\Test\WalkAir.xlsx")

        'Extract
        MyExcel.Sheets("sheet1").Activate()
        MyExcel.Range("A99").Activate()

        MyExcel.ActiveCell.Value = TextBox1.Text


        MyExcel.SaveAs("C:\Test\alkAir.xlsx")
        MyExcel.Workbooks.Close()
        MyExcel = Nothing

    End Sub

While debugging the code it resulting with me an error message asPublic member 'SaveAs' on type 'ApplicationClass' not found.

I would be much obliged if you can help me in this issue.

Best Regards

[Reverend Jim]

Just use the SaveWorkspace method with the desired filename.

[m4_prashanth]

Just use the SaveWorkspace method with the desired filename.

It result with me the same error

[Reverend Jim]

Try

MyExcel.Workbooks(1).SaveAs(filename)

or

MyExcel.ActiveWorkBook.SaveAs(filename)