How to connect VB6 to MSExel
-
I am new to the vb. I am trying to do a project which have a link between a sheet of an excel document what i want is to retrieve values from particular row/coloumn and to pass that to other pls help me by giving suitable codes Faithfully Jijo thomas
-
I am new to the vb. I am trying to do a project which have a link between a sheet of an excel document what i want is to retrieve values from particular row/coloumn and to pass that to other pls help me by giving suitable codes Faithfully Jijo thomas
Jijo, I have been fighting with a similar problem for months. Nothing seems to work for me but this code might give you a start. Set AppExcel = CreateObject("Excel.Application") AppExcel.Workbooks.Open FileName:="Put Your Excel Address Here.xls" Hope you have better luck than I have been! Garner