How Can You Fix PC Dll Errors Effectively?: How to Fix

2016年2月24日星期三

How to Fix - Trying to give good header?

Trying to give good header

Hi, I am using below code for importing all multiple files data into maser sheet.

It is only importing excel files in a folder.

What I want is, import all data excel format and csv format file also.

Can you help on this?

Below is the code I am using.

Private Sub CommandButton3_Click()
Dim strPath As String
    Dim strFile As String
    Dim wbkSrc As Workbook
    Dim wshSrc As Worksheet
    Dim wshTrg As Worksheet
    With Application.FileDialog(4) ' msoFileDialogFolderPicker

     MsgBox "All existing data will be cleared" ' for exixting data cleared
    Range("a2:t65536").Select
    Range("a2:t65536").Clear

        If .Show Then
            strPath = .SelectedItems(1)
        Else
            MsgBox "You didn't select a folder", vbExclamation
            Exit Sub
        End If
    End With
    Application.ScreenUpdating = False
    If Right(strPath, 1) <> "\" Then
        strPath = strPath & "\"
    End If
    Set wshTrg = ActiveSheet
    strFile = Dir(strPath & "*.xls*")

    Do While strFile <> ""
        Set wbkSrc = Workbooks.Open(strPath & strFile)
        Set wshSrc = wbkSrc.Worksheets(1)
        wshSrc.Range("A2:T65536").Copy
        wshTrg.Range("A" & wshTrg.Rows.Count).End(xlUp) _
            .Offset(1, 0).PasteSpecial xlPasteValues

        Application.CutCopyMode = False
        wbkSrc.Close SaveChanges:=False
        strFile = Dir
    Loop
    Application.ScreenUpdating = True

    MsgBox "Data Import successful"
    End Sub
Thanks,
Chandru

Anwsers to the Problem Trying to give good header

Download Error Fixer for Free Now

You need to not copy the header, so change

Else
            'wshSrc.Range("A2:T" & wshSrc.Cells(wshSrc.Rows.Count, "T").End(xlUp)).Copy
            wshSrc.Range("A1").CurrentRegion.Copy
        End If

to

Else
            'wshSrc.Range("A2:T" & wshSrc.Cells(wshSrc.Rows.Count, "T").End(xlUp)).Copy
            wshSrc.Range("A1").CurrentRegion.Offset(1,0).Copy
        End If

If you failed to fix it, another option is to call Microsoft and walk through the process with a technician. To do this, dial "1-800-936-5700". Explain the error that you received and the steps in the update process during which it was displayed. The technician will be able to walk through the steps from getting a new product key to finishing the installation.