Not recognising my objExcel

[mv8167]

This has been a mystery to me. When to Set my objExcel. You can say that I am very confussed.

Currently, I create a great spreadsheet called DocViewHref. I save the file then I want to use the data in my spreadsheet.

I am however getting a Run Error while accessing my data.

Object required: 'objExcel'
Function file: O:\QTP Tests\LibraryImageAccessTests-2.qfl
Line (151): " ReportType = objExcel.Cells(r,3).Value"

...

Code:

' START NEW FUNCTION FOR VIEW, ZIP, FAX AND OTHER (DOCVIEW) Dim objExcel, objFso Call KillExcel Call KillPDF Call CountNumberofDocViewsLinksHrefs (objExcel, rNumber) 'Create Excel Spreedsheet 'Set objExcel = CreateObject("Excel.application") 'Create a new Microsoft Excel object 'Keep the iterations under 20 (equates to 5 DocTypes) If rNumber > 21 Then rNumber = 21 End If For r = 2 to rNumber ' loop thru your DocView values (from 2 to rNumber or set to #) 'DocView ReportType = objExcel.Cells(r,3).Value 'abs_x location absX = objExcel.Cells(r,4).Value 'abs_y location absY = objExcel.Cells(r,5).Value 'Href Hreff = objExcel.Cells(r,6).Value ...

This use to work. Im not sure if I need to reset the objExcel or not. I do not think I do.

The Call creates and saves the spreadsheet to O:\QTP Tests\QTPOutputData\DocViewHref.xls. The spreadsheet remains open.

What do I need to do differently to access my ss?

thxx

[rajpes]

objExcel.Cells(r,3) ??
how can you access a cell value without creating instances of workbook and worksheet

[guin.anirban]

mv8167
Suggesting to make some google search before posting any new thread...