General information
Category:
ActiveX controls in VFP
Title:
PasteSpecial in Excel
I am trying to understand the activeX controls a little better. I have been able to figure a few out, but the paste special transpose is causing me some problems. I understand the VB line
object.PasteSpecial(Paste, Operation, SkipBlanks, Transpose)
I can get these two lines to work, which paste values. Unfortunately, my limited knowledge of the activeX controls is causing me to hit a roadblock. I have about 70 columns that need to be converted into rows and there are about 250 lines in each row. I can go through the sheet one cell at a time, but it would take a long time and the paste special transpose would work faster.
oXL.Selection.PasteSpecial(-4163)
oXL.ActiveCell.PasteSpecial(-4163)
Can anyone help me in getting the transpose to work?
I have looked in the visual basic object browser and can find the paste special syntax for basic. Is there anywhere (books, web sites) that I can find help in converting that to VFP so I will not have to ask what is probably a dumb question.
Thanks
Todd
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