Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find in Excel.
Message
 
 
To
15/02/2001 09:03:06
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
00475826
Message ID:
00476317
Views:
39
>Thank you,
>I have change the code as
>Fc = oExcel.Worksheets("Sheet2").Columns("A").Find("100")
>After searching i have do this.
>IF FC = .NULL.
> .....
>ENDIF
>Fc return .null. but the if endif statement does not work.
>Why

A comparision of any variable to .NULL. returns .NULL., which is not .T. or .F., so the IF statement fails. Try this, instead:
IF ISNULL(FC)
  ...
ENDIF
- della
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform