Excell Automation

Hi ther

I am trying to use the insert command from foxpro but keep getting an error, the vb syntax is

Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromRightOrBelo

it's the shift things such as xldown or before on other commands that i am struggling with

foxpro intelisence gives you insert([shit as variant] ....etc I'm not sure how to use this

thank

Ke

Cindy
Tue Mar 02 12:53:15 CST 2004

In news: 5683B387-EF8B-49C8-BE62-EB7A944447F3@microsoft.com,
Ken Olesinski <anonymous@discussions.microsoft.com> wrote:
> I am trying to use the insert command from foxpro but keep getting an
> error, the vb syntax is
>
> Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromRightOrBelow
>
> it's the shift things such as xldown or before on other commands that
> i am struggling with.
>
> foxpro intelisence gives you insert([shit as variant] ....etc I'm
> not sure how to use this.

Hi Ken,

You can see the values of the Excel constants in several ways. They are
available through the Excel Object Browser, where you can put them in the
Search Text box and the values show in the bottom band. They are also
available through the VFP Object Browser.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org www.cindywinegarden.com

Rick
Tue Mar 02 18:08:38 CST 2004

Ken,
Besides the constants, you'll need to find the proper parameter order =
for this method - VFP doesn't support named parameters.

Rick

"Ken Olesinski" <anonymous@discussions.microsoft.com> wrote in message =
news:5683B387-EF8B-49C8-BE62-EB7A944447F3@microsoft.com...
> Hi there
>=20
> I am trying to use the insert command from foxpro but keep getting an =
error, the vb syntax is =20
>=20
> Selection.Insert Shift:=3DxlDown, =
CopyOrigin:=3DxlFormatFromRightOrBelow
>=20
> it's the shift things such as xldown or before on other commands that =
i am struggling with.
>=20
> foxpro intelisence gives you insert([shit as variant] ....etc I'm not =
sure how to use this.
>=20
> thanks
>=20
>=20
> Ken
>

Anders
Tue Mar 02 19:20:26 CST 2004

Ken
#DEFINE xlDown -4121
#DEFINE xlFormatFromRightOrBelow 1

With .ActiveSheet
.Selection.Insert(xlDown, xlFormatFromRightOrBelow)

I suppose it's the Range.Insert function
Function Insert([Shift], [CopyOrigin])

You'll find the most complete list of Excel constants in the Object Browser
in Excel. Open Excel, hit Alt+F11, then F2 and you're in the Object Browser.
-Anders

"Ken Olesinski" <anonymous@discussions.microsoft.com> wrote in message
news:5683B387-EF8B-49C8-BE62-EB7A944447F3@microsoft.com...
> Hi there
>
> I am trying to use the insert command from foxpro but keep getting an
error, the vb syntax is
>
> Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromRightOrBelow
>
> it's the shift things such as xldown or before on other commands that i am
struggling with.
>
> foxpro intelisence gives you insert([shit as variant] ....etc I'm not
sure how to use this.
>
> thanks
>
>
> Ken
>

anonymous
Wed Mar 03 06:41:06 CST 2004

Hi Ken

I have a complette list, I would send it to you, but I do not know how I can send an attachment

Sandor