I am really poor with VBA. Here is my request.
I have a bunch of files I FTP monthly. They land as .dat files.
Example: member_data.dat
Currently, I manually rename in Windows Explorer and then I use a macro to import the .txt file.
Is there a way to have a module perform the rename?
thanks...