Keep sheet names unchanged after saving them as txt files.

[aadpors]

I want two sheets of my Excel workbook to be saved as txt file. The name of the file is compiled of a fixed part ("TrialList" or "BlockList") and two values from another sheet (subject and session number):

Please Login or Register  to view this content.

Now, saving the text files with the desired file names works perfectly. However, Excel decides to change the names of the sheets that have been saved as text files accordingly. This is something I want to prevent from happening, since a second loop of actions will end because of the unexpected sheet names... How do I work around this autonomous behaviour of Excel?

[adyteo]

Excel automatically does that. You need to capture the original names of the sheets and after the save, rename the sheets with their original name.