chokka
asked on
Excel VBA - Input past end of file Error !!
VBA Code reads CSV file which i try to Import to an Excel Sheet. I am able to import a CSV file but getting an exception error on another file.
Error :
Run-time error '62':
Input past end of file
While FileTextStream.ReadLine <> "Invoice Date,Invoice Number,Account Number,DEA Number,Sales Rep,,,,,,,,,,"
Wend
Error :
Run-time error '62':
Input past end of file
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@imnorie, Yes that code works fine.
I used a test file TestFile.csv
When I try to import actual file which is on the same format, i am facing the error FileStream End Error.
I used a test file TestFile.csv
When I try to import actual file which is on the same format, i am facing the error FileStream End Error.
ASKER
And (Not FileTextStream.AtEndOfStre
I have attached csv file to import Excel. Button event in the excel to import the csv file.
Open in new window
Test-6619289--5-30-2013.csvImportCSV.xls