OpenEdge 10.2b
Windows XP
Excel 2007
I have a csv file that I am importing into an Excel spreadsheet using the OpenText command. This spreadsheet has one column that can contain a either text (ABC11111X) or can have numbers with leading zeros (003847646).
The OpenText command removes the leading zeros when importing the data. I need it to keep these zeros when loaded.
Progress claims that you can pass an array to a COM object in OE10 and has even given an example in their KB (https://progress.my.salesforce.com/articles/Article/000028089?popup=true). However, this code won't even compile for me ("Only individual array elements allowed in expressions (361)").
There should be a way to send the FieldInfo the arrays it seeks. I've tried "Array(Array(1, 2), Array(2, 2))", both hard-coded and in a variable. My program compiles but doesn't work. (I've used the Array string in previous macros with success.)
Has anyone been able to find a way to use OpenText and not truncate leading zeros?
(I must open the csv file using the OpenText command.)
Any guidance will be greatly appreciated.
Windows XP
Excel 2007
I have a csv file that I am importing into an Excel spreadsheet using the OpenText command. This spreadsheet has one column that can contain a either text (ABC11111X) or can have numbers with leading zeros (003847646).
The OpenText command removes the leading zeros when importing the data. I need it to keep these zeros when loaded.
Progress claims that you can pass an array to a COM object in OE10 and has even given an example in their KB (https://progress.my.salesforce.com/articles/Article/000028089?popup=true). However, this code won't even compile for me ("Only individual array elements allowed in expressions (361)").
There should be a way to send the FieldInfo the arrays it seeks. I've tried "Array(Array(1, 2), Array(2, 2))", both hard-coded and in a variable. My program compiles but doesn't work. (I've used the Array string in previous macros with success.)
Has anyone been able to find a way to use OpenText and not truncate leading zeros?
(I must open the csv file using the OpenText command.)
Any guidance will be greatly appreciated.