Good morning guys,

does any one know how I can rename a file using VBA code.

I display a file dialog box allowing the user to pick a .csv file. Because
of the quirks of Excel I need that file to come in as a .Txt file.
I do not want the user to have to rename the file as the existing .csv file
is created by a third party program. My VBA macro then reads the .Csv file
and does it's thing. I need it to be .Txt. How do I rename the file in the
directory before I open it.

Thanks for any help.

Best Regards,

Steve Wilson.