Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vfp - excel programming
Hi,
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 With Range("e5").validation .Add Type:=xlValidateWholeNumber, AlterStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="5", Formula2:="10" .InputTitle = "Integers" .ErrorTitle = "Integers" .InputMessage = "Enter an integer from five to ten" .ErrorMessage = "You must enter a number from 1 to 10" End With Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vfp - excel programming
Hi
what is 'VFP'? -- Regards Frank Kabel Frankfurt, Germany wrote: Hi, 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 With Range("e5").validation .Add Type:=xlValidateWholeNumber, AlterStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="5", Formula2:="10" .InputTitle = "Integers" .ErrorTitle = "Integers" .InputMessage = "Enter an integer from five to ten" .ErrorMessage = "You must enter a number from 1 to 10" End With Thank you |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
vfp - excel programming
what is 'VFP'?
Probably Visual FoxPro. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Frank Kabel" wrote in message ... Hi what is 'VFP'? -- Regards Frank Kabel Frankfurt, Germany wrote: Hi, 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 With Range("e5").validation .Add Type:=xlValidateWholeNumber, AlterStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="5", Formula2:="10" .InputTitle = "Integers" .ErrorTitle = "Integers" .InputMessage = "Enter an integer from five to ten" .ErrorMessage = "You must enter a number from 1 to 10" End With Thank you |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
vfp - excel programming
aaaah
thanks Chip :-) -- Regards Frank Kabel Frankfurt, Germany Chip Pearson wrote: what is 'VFP'? Probably Visual FoxPro. "Frank Kabel" wrote in message ... Hi what is 'VFP'? -- Regards Frank Kabel Frankfurt, Germany wrote: Hi, 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 With Range("e5").validation .Add Type:=xlValidateWholeNumber, AlterStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="5", Formula2:="10" .InputTitle = "Integers" .ErrorTitle = "Integers" .InputMessage = "Enter an integer from five to ten" .ErrorMessage = "You must enter a number from 1 to 10" End With Thank you |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
vfp - excel programming
Visual FoxPro.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Frank Kabel" wrote in message ... Hi what is 'VFP'? -- Regards Frank Kabel Frankfurt, Germany wrote: Hi, 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 With Range("e5").validation .Add Type:=xlValidateWholeNumber, AlterStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="5", Formula2:="10" .InputTitle = "Integers" .ErrorTitle = "Integers" .InputMessage = "Enter an integer from five to ten" .ErrorMessage = "You must enter a number from 1 to 10" End With Thank you |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
vfp - excel programming
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...s/autofox.htm). Also, the VFP7 and VFP8 Intellilsense helps a lot. -- Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP www.cindywinegarden.com |
#7
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 . |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
vfp - excel programming
In news: ,
wrote: ...... VFP8 Intellilsense helps a lot. Let me add that what I usually do when I'm trying to figure something like this out is to instantiate oExcel in the VFP Command window and try the commands one-by-one until I get them right. Then I copy the ones that work to my PRG file. -- Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP www.cindywinegarden.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Or Excel Programming | Excel Worksheet Functions | |||
excel programming | Charts and Charting in Excel | |||
Excel Programming with VBA | Excel Programming | |||
Excel Programming | Excel Programming | |||
Excel Programming | Excel Programming |