Hello,
I have multiple dat files and want a macro that will put each file into a new excel workbook, with each dat file in a separate sheet. Found a macro on this site that might work, but the tab name has to be a specific name. Is there a way the macro would work no matter what the sheet name is? The files are in the same folder on the C drive. Also is there a way to move the files once they are copied into a subfolder called backup?
Thanks!
I have multiple dat files and want a macro that will put each file into a new excel workbook, with each dat file in a separate sheet. Found a macro on this site that might work, but the tab name has to be a specific name. Is there a way the macro would work no matter what the sheet name is? The files are in the same folder on the C drive. Also is there a way to move the files once they are copied into a subfolder called backup?
Thanks!