Workbooks.OpenText dropping last char from input
Interesting note:
I just found one row in my data that the last 4 bytes are "027X" and the
parsing into col U and V was correct; 027 in col U and X in col V
Most of the rows have just 027_ (for example; _ = space, or actually inplace
of the space, there is a <CR) in the last 4 bytes. In these cases, "2"
shows in col U and "7" shows in col V
But there should not even be a Col V the way the current code is set up.
--
Regards,
John
|