>*** how to enable intellisense in PRG or FORM
>
>LOCAL oexcel as excel.application   
>LOCAL oWorkbook as excel.application   
>oexcel =createobject('excel.application')
>
>oexcel.    && intellisense working
>oWorkbook.     && intellisense working
>
>
>LOCAL oPivotCache as ...
>
>oPivotCache = oWorkbook.PivotCaches.Add( 2 ) && external data
>
>oPivotCache.   && how intellisense this 
>
>
>** in command window it is working perfectly.
>
>** please try in command window
>
>
>

LOCAL oexcel as Excel.Application   
LOCAL oWorkbook as Excel.WorkBook
LOCAL oPivotCache AS EXCEL.PivotCache

oexcel =createobject('excel.application')

oexcel.        && intellisense working
oWorkbook.     && intellisense working
oPivotCache.   && intellisense working