pbosek 0 Newbie Poster

I open a excel workbook with a name given in a text box, say XXX. The vbp also allows the user to select multiple csv files. I need to open csv files one after the other, get some values and then close. How do i open files in new tab/spreadsheet of the same excel XXX.
thanks in advance