VBA Code to Change File Extension

Hi,

I'm looking for code to rename a file C:\Closing.Lis to C:\Closing.Txt from an Access module.

Thanks

m

Re: VBA Code to Change File Extension

Thanks Norie.

The Name statement worked great - but only once. Apparently, it won't overwrite a file if it already exists. In other words, if closing.txt already exists, and I run this command:

Name "C:\Closing.Lis" As "C:\Closing.Txt"

Then I get the following error:

Quote

Run-time error '58':

File already exists

Any thoughts?

m

Re: VBA Code to Change File Extension

Norie - You Rock !

Thanks a mil.

m