Import CSV and XLSX

[emukiss10]

Hello,

I have a little problem. I want to import files to excel - different files to different sheets but I cannot manage to set two extensions at once.

I like Excel to import chosen XLSX and CSV to separate sheets. I dont know how to set more than one extension.

Im useing this code to import xls files

    Dim xFilesToOpen As Variant
    Dim i As Integer
    Dim xWb As Workbook
    Dim xTempWb As Workbook
    Dim xDelimiter As String
    Dim xScreen As Boolean
    On Error GoTo ErrHandler


    xDelimiter = "|"
    xFilesToOpen = Application.GetOpenFilename("Wycena i Eru (*.xls), *.xls", , "", , True)
    If TypeName(xFilesToOpen) = "Boolean" Then
        MsgBox "No files were selected", , ""
        GoTo ExitHandler
    End If
    i = 1
    Set xTempWb = Workbooks.Open(xFilesToOpen(i))
    xTempWb.Sheets(1).Copy
    Set xWb = Application.ActiveWorkbook
    xTempWb.Close False


    Do While i < UBound(xFilesToOpen)
        i = i + 1
        Set xTempWb = Workbooks.Open(xFilesToOpen(i))
        With xWb
            xTempWb.Sheets(1).Move After:=.Sheets(.Sheets.count)
        End With
    Loop
ExitHandler:
    Set xWb = Nothing
    Set xTempWb = Nothing
ErrHandler:

best regards
w.

 

[Joe4]

Try changing the "*.xls" references to "*.*"

 

[emukiss10]

Thank You.

But I would like to narrow choices to just CSV and XLSX.

To many to choose from and people are going crazy

 

[Joe4]

But I would like to narrow choices to just CSV and XLSX.

To many to choose from and people are going crazy

I don't think that is easily done, unless they both contain the same prefix.
If you don't want to show all, then I suggest maybe doing two OpenFileName blocks, one for the XLSX and one for the CSV.
Maybe preface it with another input box asking them what type of file they wish to open, and then go to the correct block based on that.

 

[emukiss10]

Ok, Thank You. I thaught i may be a little tricky.

 

[Joe4]

Ok, Thank You. I thaught i may be a little tricky.

Yes, I am not sure how to do both (or even if it is possible).
But it should be pretty straightforward to do the extra Input Box asking what kind of file that they would like to imports, and then present the correct OpenFile dialog.