Using VBA, I would like to copy the whole data from multiple text files to multiple excel spreadsheets with the same name as the original text file. Objective is to basically convert txt data into excel data.

I use MS Office 2016.

Can someone help me?

I tried to google, but most results I got were to copy data from multiple text files to single spreadsheet.