Version 3.70.B
When importing data from an Excel file, is there a way to get Excel to return the character length of the cell value before trying to assign the value to a variable?
The problem that I have is that if a cell contains more than 1024 characters then it will bomb out with out completing the rest of the data and without informing the user of the cell address causing the problem.
I can handle all other issues if only I could first test the length of the cell value.
Any help greatly appreciated.
Thanks,
Simon
When importing data from an Excel file, is there a way to get Excel to return the character length of the cell value before trying to assign the value to a variable?
The problem that I have is that if a cell contains more than 1024 characters then it will bomb out with out completing the rest of the data and without informing the user of the cell address causing the problem.
I can handle all other issues if only I could first test the length of the cell value.
Any help greatly appreciated.
Thanks,
Simon