kindly tell me to save as a file in MS Excel 2007 by run/ record a macro, VBA or any other method.
File should be save in one folder with different names automatically or by entering file name manually. Please send me its coding or related video

Thanks & Regards