Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation Help
Message
From
07/04/2004 13:05:18
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00891618
Message ID:
00892987
Views:
51
>That was excellent and worked as advertised, but when I try to apply the same technique on another spreadsheet, I get the error: "Unable to get the Insert property of the Range class"
>
>The working excel macro is:
>
>    Range("B3:C31").Select
>    Selection.Copy
>    Selection.Insert Shift:=xlToRight
>
>
>And my attempted VFP code to do the same thing is:
>
>oExcel.WorkBooks.Open(THISFORM.cdatapath+[YugiohTemplate.xls])
>oRecapSheet = oExcel.Activesheet
>#Define xlShiftRight -4152
>WITH oRecapSheet
>    FOR i = 3 TO nColumnCount STEP 2
>	.Range("B3:C31").Copy
>	.Range("B3:C31").Insert(xlShiftRight)
>    NEXT
>ENDWITH
>
>
>Can you tell me what I'm missing?
>
>Much thanks in advance!

>#Define xlShiftRight -4152

Is it true ?
Try with -4161
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform