This content has been marked as final. Show 6 replies
For i = 4 To OraDynaSet.RecordCount
I believe you are starting on the fourth record...
Octavio, You are correct, I overlooked that, how can I insert Column headers then, any idea? I tried to insert them using some VB code before all of the code I posted above.
Thanks for the Help!
You can do it this way:
If OraDynaSet.RecordCount > 0 Then
insert your Column Headers
Let me know if it worked.
I get a Run-time error '440'
OIP-04108: Invalid row reference
The debugger is pointing to the line " OraDynaSet.CopyToClipboard -1 "
I just placed this after the If statement that enters all the data.
Selection.insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
then insert column headers.
It's a bit weird. It works for me. If you have a look at oo4o help:
Copy the rows from the dynaset to the Clipboard in text format.
OraDynaset.CopyToClipboard(NumOfRows ,colsep [optional],rowsep [optional] )
NumOfRows Number of rows to be copied to the dynaset ,
colsep Column separator in CHAR to be inserted between columns
rowsep Row seperater in CHAR to be inserted between Rows
This method is used to facilitate transfer of data between Oracle Object for OLE’s cache (dynaset) and Windows applications such as Excel or Word. CopyToClipboard copies data starting from current position of the dynaset up to the last row.
Default column separator is TAB (ASCII 9).
Default row separator is ENTER (ASCII 13).
Can it be that you don't have all the References needed?