ActiveSheet change form VB.NET

[mqdias]

Hi,

I'm developing an little application with VB.Net, that involve Excel.

I am copying Textbox contents to Excel cells. I have the following code to copy them to "Sheet1".

xllm = xl.Workbooks.Open(Filename:= _
        "c:\Programas\Energest\Inventor-Propriedades\Lista Material.xls")

        xl.Visible = True
        xlwb = xl.activeWorkbook
        xlws = xlwb.ActiveSheet

Now, i want to change the Activesheet to "Sheet2" to copy some values, and return to activate "Sheet1" again.

How can i do this?

thanks

[Blasphemer]

Bump, I have the same question Any help?

[RobDog888]

Welcome to the Forums.

Usually its best to start your own thread but since there is only 1 post I will leave it.

xlws = xlwb.Worksheets("MySheet").Activate

[Blasphemer]

Thanks, Rob.