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".Now, i want to change the Activesheet to "Sheet2" to copy some values, and return to activate "Sheet1" again.Code:xllm = xl.Workbooks.Open(Filename:= _ "c:\Programas\Energest\Inventor-Propriedades\Lista Material.xls") xl.Visible = True xlwb = xl.activeWorkbook xlws = xlwb.ActiveSheet
How can i do this?
thanks




Reply With Quote