Macro to change file types

Is there a macro that can change all the files in a location to .csv files.
I am working on a macro that lets me open a file at a specific location it works, but I have to change the file type to .csv 1st. I was hoping the macro could do it for me.
Here is some of the code and the location of the need to be .csv files:

Please Login or Register  to view this content.

So, I need code that will go to that path and change all files to .csv files before I go there with this string of code to open the desired files.
Thank you very much for your time and help.

Hello Erock24,

I revised your macro to include the code needed to rename the file the user selects as a CSV file.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

I'm getting a large error message saying the file can't be found. It's run time 1004

It highlights in yellow this:

Please Login or Register  to view this content.

Hello Erock24,

Forgot to change that the last line. Should be...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Wow. that Works great thank you very much. awesome.