Is it possible to change a file name within Excel VBA? I cannot find the syntax.
In my procedure, I create a TEMP text file to hold the results of an extract. At the end, I want to change the name of the file from ??.tmp to ??.txt. I cannot use the final name; because that is the name of the file I am originally pulling from.
Is this a call to the Windows API?