>Dear Sir,
>
>Please aslo translate following VBA codes into VFP
>
>ActiveSheet.Shapes("Text Box 1").Select
>Selection.ShapeRange.ZOrder msoSendToBack
>Selection.ShapeRange.ZOrder msoBringToFront
>
>And what Excel constants will be use?
>
>Please help
#define msoSendToBack 1
#define msoBringToFront 0
oExcel.ActiveSheet.Shapes("Text Box 1").Select
oExcel.Selection.ShapeRange.ZOrder(msoSendToBack)
oExcel.Selection.ShapeRange.ZOrder(msoBringToFront)(not tested)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
