Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation Help
Message
 
To
02/04/2004 03:34:48
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00891618
Message ID:
00892973
Views:
46
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!
Kogo Michael Hogan

"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?

Ideate Web Site
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform