R
Robert
I'm having issues using the Public Sub ImportTextFile from the
cpearson site. I am trying to import a datafile that was written
using VMS's DCL language. When I manually copy and paste the data
into an excel sheet, the file shows up correctly. When I try and use
the ImportTextFile to do it instead, it puts all the data in cell A1.
I will gladly send someone some sample output -- if I paste it here
the carriage return is changed and then it magically works.
I think there is a problem with the way the carriage return is
interperated, but I'm not sure. Does anyone know a way to import into
excel from VMS so it shows up correctly?
cpearson site. I am trying to import a datafile that was written
using VMS's DCL language. When I manually copy and paste the data
into an excel sheet, the file shows up correctly. When I try and use
the ImportTextFile to do it instead, it puts all the data in cell A1.
I will gladly send someone some sample output -- if I paste it here
the carriage return is changed and then it magically works.
I think there is a problem with the way the carriage return is
interperated, but I'm not sure. Does anyone know a way to import into
excel from VMS so it shows up correctly?