hi !
how can i import data from text file to excel(VBA), as my data has commas ,qoutes delimiters .
thanks in advance.

Try renaming the file if necessary with .txt suffix and use Excel File/Open.
The problem might be the " text delimiter. Can remove this in a text editor with Edit/Replace " with nothing.


-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.

Hi
Here is an example.

Sub ImportData()

    'Filename = the full path to Your txt file eg."C:\MyDocuments\Mytxt.txt"
    Open Filename For Input As #1
    Do While (Not EOF(1))
        ' In this case the file is delimited by , and contains several lines
    ' Read the file one line at the time
    Input #1, Streng

    'Input streng into and array
    StrArray = Split(Streng, ",")
    Call WriteToExcel(StrArray)
    Loop
    Close #1
End Sub

Sub WriteToExcel(StrArray)
     For J = LBound(StrArray) To UBound(StrArray)
     'Do what you want to do with the data
    Next J
End Sub

Hope this is what you are looking for.

Cheers
Karsten