VBA code to save same file with different name in another folder without replace original files

#vba code to save same name file with different name in other folder without replacing original file using fso object or file system object

[bhar]

Hi, do you by any chance have any guides on how to save the same file as different names in a folder? Basically as an example, let's say you have a drop-down menu in a sheet from Data validation that you select different sales categories and when you select each category, you can see different data displayed as it relates to that category but you want to save a copy as a different file name as it corresponds to whatever you selected. So if you select Fruit sales from the dropdown, you'd get fruit sales data and then it would save a copy of the worksheet called Fruit Sales, then select the next category which is Vegetable sales - get that data and save a copy as vegetable sales. Do you have any kind of guide on something like that? Can it even be done?

[Gayushreee]

How to copy and replace without changing name?

[lila-x]

Thanks for this tutorial. If I wanted to save the files into another folder but renaming it with the same filename but adding on today's date. Is that possible please?

[ManishJain-vpqu]

Can you share the code to copy one file to copy in other folder with multiple name without replace original file.

[Jambin]

Great video!
Can this work with folders and files?
I tried running your code, and would like Folders to be copied and the contents within them as well.

I would like to be able to paste many directory paths in Column A, to specific paths pasted in Column B on the same row.

I have to copy all original files and folders, then have everything copied be renamed just like you have here as "Copy"

Thank you!