Copy File To Same Parent Folder

[NeedForExcel]

Hi,

I have a script that has the following line which is not working.

Please Login or Register  to view this content.

What I basically want is, copy a file and paste it there (In the folder where the original file is) itself.

The motive behind this is to create a copy of the file.

However, when I change the path to some place else, it works, but it does not create a copy in the same folder itself. Can anyone guide.

To understand what I mean, put a dummy file is a folder. Copy the file, and paste it there itself. This is the action I am trying to automate.

[AlphaFrog]

I'm assuming this is using File System Object. If yes, give the file a new unique file name because it's in the same folder as the original. The code below inserts a (2) to the file name.

Please Login or Register  to view this content.

[NeedForExcel]

Hi AlphaFrog, thank you for the reply. I had actually figured that out.

I just want to know if there is a way as simple as pasting the file, and it will automatically get the next number.

In your solution, (2) is hard coded, and if a file already exists with that name, it will error out.

However, when you copy a file in a folder and keep hitting Ctrl+V it automatically gets the next number.

I want to replicate this behaviour using VBA.

[AlphaFrog]

I don't know of a built-in "automatic" method to sequentially number the files. You could have the code loop through all the files in the folder to find the max sequential number and then increment it by 1 for the next save. Alternatively, a common practice is to concatenate the Date-Time to the file name to make it unique.

[IonutC]

Hi Need,

It is simple to use a code like the one below:

Please Login or Register  to view this content.

the code from above is an example. you can customize yours in order to have a specified path to save these files. In my example I have a folder on my desktop named "MacroFiles".

[NeedForExcel]

@ALphaFrog - Thank you for the help..

@IonutC - Thank You For The Help! However, I know that bit you told me, just wanted a know of a way to replicate the behaviour mentioned in Post #3 Thank you anyways.

Reps added to both.