View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Keith[_2_] John Keith[_2_] is offline
external usenet poster
 
Posts: 175
Default 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