Hi All Can U Please Help me to Change The file Which i Using to Save Excel File To CSV Accordingly. Please Find the Attached Sample File.

I need Do Some Changes For Current VBA Which i Using to Change File Path , File Name, File Range. If i Change from the Current Sheet Example E1,E2,E3 When I change E1 it should Change file Path When I Change E2 it Should Change File Range When I Change E3 it Should Change File Range

Also When i Save File to CSV Date Should Be Same As Shown 01/07/2013


SaveDataAsCSV.xlsm


Thanks
Regards