How to define range in vb6 and to be written in excel

[Preetish]

I used Excel file to make some computational work, and the number of rows have been filled with the numbers and when I do the computation for these numbers then sometimes its value remains countless and that i traced out two to three times, does anyone knows how to write range for number of rows to calculate.

Thanks

[BlackSunReyes]

Yes, you need to add the Microsoft Scripting Runtime reference. May I ask if you are creating the Excel file with it or ??? go to the "Project" menu, and select "References". You will be presented with a long list of available references, just scroll down to "Microsoft Excel X.X Object Library"

[Samra]

If you wanted to wtrte the give Add a reference to Microsft excel object library:

Option Explicit

Private Sub Command1_Click()
Dim xlApp As Excel.Application
Dim wb As Workbook
//You need to wite the following source code then you need to set up an answer.

Set xlApp = New Excel.Application

Set wb = xlApp.Workbooks.Open("PATH TO YOUR EXCEL FILE")

Set ws = wb.Worksheets("Excel Sheet1") 'Specify your worksheet name
var = ws.Range("A1").Value

or
var = ws.Cells(1, 1).Value
wb.Close

xlApp.Quit

[machok]

Although your Typename <> "Nothing" left me perplexed. Instead of a string compare, you have a reference set up, you can create an instance of Excel. To do this you declare an object variable with a data type of Excel.Application, and then you can do whatever you want with it, before closing/disconnecting from it. Or else you can open an existing worksheet file and read it, you can create a new one and save it, you can basically do anything that a user in Excel can do.