If it is created by your macro, why not assign it a name with the extension
you want and just avoid the need to rename it.

--
Regards,
Tom Ogilvy

"Stanley Lam" wrote in message
...
Bob,

Thanks for your reaction!

The file that has been made, I have to upload it to another application.
But in order to make this work, there are 2 things that has to been done
before uploading it:
1. the file has to be saved as a *.prn
2. the extension has to be removed

So the type of file is created by my macro (*.prn), but the final step
removing the extension still has to be made.



Stanley


*** Sent via Developersdex http://www.developersdex.com ***