Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Line Input Not behaving...!
*** Trying to read an External CSV file ***
however Have found the EOL marker in the file is CHR(10) and not Chr(10)+Chr(13). The CSV file is from an external Source and i am unable to Change the Format (EOL character etc.). Sub Import ( ) CSVLine = 0 CsvFile = Application.GetOpenFilename("Comma Sep Values (*.csv), *.csv") Open CsvFile For Input As #1 While Not EOF(1) Line Input #1, aRecord ' Other Parsing Code Is Here.. ' ... ' ... CSVLine = CSVLine + 1 Wend Close #1 msgbox Str(CSVLine)+": Lines Read" '*** CSVLine Only ever reaches 1 *** End Sub Is there another Setting to Change the behaviour of Line Input #1 .... ? the Lines are not a set length so am unable to read a set number of Characters etc. Any Feedback would be Appreciated. Andrew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Input not finding Chr10 or 13 | Excel Programming | |||
Multi line merged cell - adapting to different size input - possible? | Excel Discussion (Misc queries) | |||
diagonal line and data input | Excel Discussion (Misc queries) | |||
line input problem-need to return 5 lines after a string is found | Excel Programming | |||
Reads entire *.txt file into string opposed to a desired line by line input. | Excel Programming |