Tried using this VBA. It opens the directory specified but can't import any file.
When opening xml file, the message displays (xml or csv file can be imported direct to workbook)
and when trying Excel file it says (Excel files can be opened to manually copy data from or certain sheets/data copied from them via VBA)