Hi there,

If the workbook name is dynamic, I have trouble renaming it from a given path. Please find the below code if the workbook name is fixed(SampleFile) and not dynamic

Name "C:\Users\Dell\Desktop\myFolder\SampleFile.xlsx" As _
"C:\Users\Dell\Desktop\myFolder\myNewFile.xlsx"
Lets assume both the paths are the same as mentioned above. Here I just need to change the workbook name.

Example : If the file name is File1, File2, FileABC or FileXYZ.

How do I change the file name to "myNewFile" if the file name is not constant.

Please, let me know if you need any further information and also I have already raised a same concern in the other forum too but I need a little earlier
https://www.mrexcel.com/board/thread...namic.1217019/

Thank you.