Hi All,
I am new user, with lack of knowledge of VBA.
I tried to create VBA code that will allow me to select multiple CSV files and open them in one excel in separate ( Not named) sheets.

My code works but works only for one file.
I wonder if multiselect works on Macintosh OS?

Basically every day i have to import 6 different CSV to separate sheets into excel. I would like to get it more automated.

This is my code.


Sub Get_data_from_file()
Dim Filetopen As Variant
Dim OpenBook As Workbook

Application.ScreenUpdating = False
FileToOpen = Application.GetOpenFilename(Title:="browse for your file & import range")
If FileToOpen <> False Then
Set OpenBook = Application.Workbooks.Open(FileToOpen)
OpenBook.Sheets(1).Range("A3:U100").Copy
ThisWorkbook.Worksheets("SVB").Range("A6").PasteSpecial xlPasteValues
OpenBook.Close False

End If
Application.ScreenUpdating = True

End Sub


Please help me to get this bug fixed.
Anna