So I have a file that I am opening with "workbooks.opentext", but the data in the file (it's an EDI payment file) is one very long line so when excel opens it the data exceeds the Excel column limit so that when the data gets transposed there is data missing at the bottom. Is there any way around this?
Bookmarks