Change the workbook name from a path without opening it(Dynamic)

[Manoj Gaidhankar]

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"

If you could please help me with the above code while the workbook name is dynamic.

Thank you.

 

[Micron]

Maybe if you provided examples of the new file path and where that value is kept...

 

[Manoj Gaidhankar]

Thank you for your reply. 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 any of the xyz names.

I hope this information helps orelse please let me know if you need anything else.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Change the workbook name without opening it (Dynamic)
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Manoj Gaidhankar]

I have posted later about this query but will try not to provide the link in the future

Change the workbook name without opening it (Dynamic)

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"...

www.excelforum.com

Thank you

 

[Manoj Gaidhankar]

Hi there, can I expect a reply