Hi,
I have different text files that I need to open in excel, run the same macro on and then save the file as an excel file using the same file name. I have the names of the files currently listed in a workbook as 3 columns - the path, the file name and then the extension. I've set it up this way because I'll need to use the macro many more times with different file names, paths and ext.
Can someone help me with the code to open up the different files and to save the file using the same path and name?
Example:
A1 - "011809" B1 - "C:\users\......" C1 ".txt"
A2 - "022109" B2 - "c:\users\......" C2 ".txt"
.....
A80 - "110109" ....
Thank you
I have different text files that I need to open in excel, run the same macro on and then save the file as an excel file using the same file name. I have the names of the files currently listed in a workbook as 3 columns - the path, the file name and then the extension. I've set it up this way because I'll need to use the macro many more times with different file names, paths and ext.
Can someone help me with the code to open up the different files and to save the file using the same path and name?
Example:
A1 - "011809" B1 - "C:\users\......" C1 ".txt"
A2 - "022109" B2 - "c:\users\......" C2 ".txt"
.....
A80 - "110109" ....
Thank you