Hi! I'm new to OLE-Automation and I would like to know how the OpenText function is used in order to read in a File with semicolon seperated data to create a new spreedsheet.
I have tried the COM Object viewer and got the following information:
Method with 16 arguments, 11 optional:
NO-RETURN-VALUE com-handle: OpenText (
Character-Filename,
anytype-Origin,
anytype-StartRow,
anytype-DataType,
Integer-TextQualifier,
anytype-ConsecutiveDelimiter,
anytype-Tab,
anytype-Semicolon,
anytype-Comma,
anytype-Space,
anytype-Other,
anytype-OtherChar,
anytype-FieldInfo,
anytype-TextVisualLayout,
anytype-DecimalSeparator,
anytype-ThousandsSeparator ).
Huh???????????? so which 5 are not optional, and what does anytype-xxx mean??????????????
Can anybody please tell me what's wrong with this statement:
chExcelApplication:Workbooks:OpenText("c:\Test.txt",2,"Semicolon",,,,TRUE).
.....Thank you
Oliver
I have tried the COM Object viewer and got the following information:
Method with 16 arguments, 11 optional:
NO-RETURN-VALUE com-handle: OpenText (
Character-Filename,
anytype-Origin,
anytype-StartRow,
anytype-DataType,
Integer-TextQualifier,
anytype-ConsecutiveDelimiter,
anytype-Tab,
anytype-Semicolon,
anytype-Comma,
anytype-Space,
anytype-Other,
anytype-OtherChar,
anytype-FieldInfo,
anytype-TextVisualLayout,
anytype-DecimalSeparator,
anytype-ThousandsSeparator ).
Huh???????????? so which 5 are not optional, and what does anytype-xxx mean??????????????
Can anybody please tell me what's wrong with this statement:
chExcelApplication:Workbooks:OpenText("c:\Test.txt",2,"Semicolon",,,,TRUE).
.....Thank you
Oliver