I feel like this must be simple, but I can't find the answer. I'm saving a bunch of csv files using vba and would like to change all the file extensions from .csv to .txt to import into another program (Revit) which only recognizes the .txt extension. Is this possible? Here is the command I'm using.
For I = 1 To WS_Count path = CurDir() + "\" + ActiveWorkbook.Worksheets(I).Name Sheets(ActiveWorkbook.Worksheets(I).Name).Select ActiveWorkbook.SaveAs Filename:=path, FileFormat:=xlCSV, CreateBackup:=False Name path As ("path" + ".txt") Next I