VB has the capacity to use named arguments. In this case, the argument is named shift. The nice thing about named arguments is that if you use the names, you can pass the arguments in any order. Also, most VB samples directly reference the constant names - which in this case is xldown.
To find the constant values, use the object browser (F2) in the VB editor of an office application. In this case, use Excel - since a reference to the Excel Application Type Library will automatically be present.
Also, search on the method of interest - in this case - the Insert Method. In VFP, you must use the default order of arguments - since VFP does not support named arguments.
Following these two steps will get you through 90% of the VBA situations you will encounter...
>I know this is a simple question, but I can not find a good source for help. What is the VFP syntax for the following Excel VB commands.
>
>Rows("1:3").select
>Selection.Insert Shift:=xldown
>
>I tried:
>ox.rows("1:3").select
>ox.selection.insert.shift(xldown)
>
>The rows are inserted in to the worksheet but I get a Foxpro error telling me:
>Member INSERT does not evaluate to an object.
>
>Can someone clear this up.
>
>TIA
>Robert
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only