Hi,

I am trying to Save .csv file as an Excel file while allowing user to choose directory and filename. In other words I have a .csv file that has a macro run on it that moves data around and the like. That is fine but when that is done I need the macro to bring up the prompt/window so the user to save this file with whatever filename they want and whatever excel version they want. Additionally I wanted to put in a default directory to the area where the file would most likely be saved to minimize user navigation through the LAN (yes the user is demanding but does sign my paycheck ).

I tried "getsavefilenameas" and I have tried several other methods (that worked when it was excel to excel) however I keep getting file type errors that say the file type does not match the file extension and thus the file cannot be opened.

Any help would be greatly appreciated.

Thanks