Append A Prefix String to Current Filename and Overwrite

Hi,

I am trying to add a Prefix string (with if condition) to the current filename and overwrite at the same location as the current file. A certain Prefix is appended to the current filename if the filename contains a partciular string such as 0915 or 1215, etc, then the file name is overwritten and saved and then moved to next file in the directory.

However, I am not getting any result and its not working, may be its having trouble with Prefix declaration, but I can't figure it out as per my very limited excel vba knowledge. How can I make it work? For which reason it isn't working, this code? The vba code is pasted below:

Please Login or Register  to view this content.

Thanks for your help.

Sanjeev.

Hi Sanjeev,

There is no need to open the Excel workbook in order to perform a rename operation.

Try the code below

Please Login or Register  to view this content.