|
I am examining the use of this UDF to read information from a single cell (i.e. Row 5, Column 7) within a spreadsheet and assign it to a variable. Then I want to display the result in a KiXform.
I have noticed that the stated action of this function is to read values from Excel to a 2-dimensional array.
In testing it with KiXtart version 4.21 and windows 2000, I have been unable to get it pull a single value out of a spreadsheet and display it. Am I using the function in a manner other than what it was designed for?
I will post the code if I am using the function as intended. If I am not, can anyone suggest a function that will read a specific cell by coordinated in Excel? I examined the ReadExcel UDF, but I'm not sure from reading the description that it will perform what I need. Can anyone shed some light on the best UDF for my situation?
| 
