I've seen various postings reading importing from Excel via automation but nothing which answers my problem.
While importing excel files using the standard excel buffer table and functions you will occasionaly get an error because a cell contains a long text (more than 250 chars).
I was investigation a solution but haven't gotten anywhere. What I'd like to do is to use the Excel vba functions on the cell contents before importing. Something along the lines of:
xlapp.vbafunctioncalls.len(XlWrkSht.Range(xlColID + xlRowID))
the idea being that the evaluation of the length of the cell be done in excel and the result returned, rather than nav extracting the contents of the cell and then passing it back to excel to calculate the length.
There is an evaluate function which can be passed a string to be evaluated but it involves jumping through hoops to construct a cell reference in text format.
Anyone done any work on this?