Posted to microsoft.public.excel.programming
|
|
vfp - excel programming
Thank you a lot Cindy!
-----Original Message-----
In news: ,
wrote:
I try to crate excel validation method in VFP but I
can't
do it. Anyone who can convert the following VB syntax
to
VFP syntax
oExcel = CREATEOBJECT("Excel.Application")
oExcel.Visible = .T. && For testing
oBook = oExcel.Workbooks.Add()
With oExcel.Range("E5").Validation
.Add(1, 1, 1, 5, 10)
*-- Look up constants in Excel Object Browser or VFP
Object Browser
.InputTitle = "Integers"
.ErrorTitle = "Integers"
.InputMessage = "Enter an integer from five to ten"
.ErrorMessage = "You must enter a number from 1 to
10"
EndWith
.....
You'll find more information about Office Automation
from "Microsoft Office
Automation with Visual FoxPro"
( http://www.hentzenwerke.com/catalogp...ts/autofox.htm
). Also, the VFP7
and VFP8 Intellilsense helps a lot.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
www.cindywinegarden.com
.
|