Results 1 to 5 of 5

Invalid Qualifier

Threaded View

  1. #1
    Registered User
    Join Date
    04-03-2012
    Location
    Italy
    MS-Off Ver
    Excel 2010
    Posts
    3

    Invalid Qualifier

    Hi! I've just started using vba, I've to solve a problem as soon as possible so I can't spend a lot of time studing...
    When I compile the code below, I have an "Invalid qualifier" error at "arr.lenght". Someone could help me?
    Thanks a lot,


    Luca


    Private Sub Invio1_Click()
            Dim i As Integer, zeta As Integer
            Dim buf As String, arr() As String
            
            abc = FreeFile
            Open ThisWorkbook.Path & "\r (1).txt" For Input As abc
            i = 1
            
            Do While Not EOF(abc)
            Line Input #abc, buf
                arr = Split(buf, Chr(9))
                For zeta = 1 To arr.lenght
                Cells(i + 12, zeta) = arr(zeta)
                Next
                i = i + 1
            Loop
        
       Close abc
    End Sub
    Last edited by arlu1201; 04-03-2012 at 07:41 AM. Reason: Put code tags for you. Please do so in future.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1