Pasting a sample code in which I am just taking a count of number of non
blank cells. You can try out some similar logic
Set ObjIPExcel = CreateObject("Excel.Application")
ObjIPExcel.DisplayAlerts = False
ObjIPExcel.Workbooks.Open FilePath
ObjIPExcel.visible=true
Set ObjIPExcel_Wb=ObjIPExcel.Activeworkbook
Set strIPSheet = ObjIPExcel_Wb.Sheets(1)
intIPCol=1
Do while strIPSheet.Cells(1,intIPCol)<>""
intIPCol=intIPCol+1
Loop
On Tue, Sep 13, 2011 at 9:05 PM, supreeth mc <[email protected]> wrote:
> Hello People,
>
> This is my first request on this Blog can any one help me out on
> this :-
> I need to compare blank cells in excel row wise is there are more then
> one blank cells then I have to jump to next row....
>
>
>
> for example:-
>
> SYID
> INFO
> Login UN PA
> INFO INFO
> URL Web Browser Buttona
> INFO INFO
> Result Module1 Module 2 Module 3
> INFO INFO
> PS: I need to fetch INFO from all these rows can any one help me with
> the codes ....Plz:)
>
> --
> You received this message because you are subscribed to the Google
> "QTP - HP Quick Test Professional - Automated Software Testing"
> group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/MercuryQTP?hl=en
--
Regards,
Ganesh Muralidharan
'God Never Forgets'
--
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en
