Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transposing a range with VFP
Message
From
02/01/2005 22:07:18
Tek Hong Yew
Visual Solutions
Kuala Lumpur, Malaysia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Transposing a range with VFP
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00973732
Message ID:
00973732
Views:
101
Hi all

I need help to automate transposing a VFP cursor that I have written to an Excel sheet. I would appreciate if someone can help to code the following in VFP code

Range("A1:B4").Select
Selection.Copy
Range("A11").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True



Thanks & Best Regards
Next
Reply
Map
View

Click here to load this message in the networking platform