This code works for a comma delimited file. What I am asking is for is a way to parse a Matrix excel spread sheet where the Column for UD2 is defined using UD2# in the first row of the named range. the delimitedparsevalue above if fine for predefined file layout but how can the data source be informed about which data element associated with the dimension (UD2)
It probably seems to work but you're relying on VB.net Coercion to force a string to be evaluated as an integer in the line:
Dim Accountcol As String = args.Value
...
If Accountcol > 39999 Then
Eventually you may see errors and might not understand them. VB is a strongly typed language and only variables of like type can be compared. You may not be doing the conversion, but its happening. By not coding it yourself, you get whatever conversion the machine decides is right for you. It may not always be what you want (hence the name Coercion).