Hello!
I have a folder with +100 files in xls format that I need to change to .txt format and save with the same name in new folder!
I did a macro for one file, but this needs to run for all the files in this folder! I need a script that can run thru all files and save them with extension ".txt"
Thanks
This is how my macro looks like:
ChDir "C:\test\xls_files"
Workbooks.Open Filename:="C:\test\xls_files\1.xls"
ActiveWorkbook.SaveAs Filename:= _
"C:\test\txt_files\1.txt", FileFormat:=xlText, _
CreateBackup:=False
ActiveWindow.Close
Bookmarks