hexagon logo

Excel CSV formatting question

In regards to how excel recieves the data, is there a way in VB script to force excel to take the information and display the results along a column as opposed to in a row?

IE:
Typical
####

Wanted
#
#
#
#

I have a file that outputs over the 16,800 something allowable column width, and in rows you can have over 1,000,000 lines.

Thank you to anyone who can assist
Parents
  • In regards to how excel receives the data...


    Receives the data from:
    PC-DMIS's PCDMIS2EXCEL wizard?
    PC-DMIS's file writing export to CSV?
    Datapage?
    A VB script that dumps data to CSV format?
    Hexagon's PC-DMIS Excel Form utility?
    One of the independently developed CSV export utilities available on the internet?

    As this is the PC-DMIS software forum, I'm moving this over to the Code section as it deals more with Excel software.
Reply
  • In regards to how excel receives the data...


    Receives the data from:
    PC-DMIS's PCDMIS2EXCEL wizard?
    PC-DMIS's file writing export to CSV?
    Datapage?
    A VB script that dumps data to CSV format?
    Hexagon's PC-DMIS Excel Form utility?
    One of the independently developed CSV export utilities available on the internet?

    As this is the PC-DMIS software forum, I'm moving this over to the Code section as it deals more with Excel software.
Children
No Data