Rename multiple files in folder

[MissaLissa]

Hi All -

I'm looking for some assistance in creating a macro which will rename files in specified folder.


FolderPath = "L:\Cognos Report Output\Change Control Reports"
Filenames contain _2A at the beginning and in the middle of the file name which I would like removed. (_2AAvg Cap Cost_2AQTR - Budget.xlsx)

Thanks in advance to anyone who can help.

[mike7952]

Give this a try

Please Login or Register  to view this content.

[MissaLissa]

Hi Mike

Oddly enough I've tried something similar to your code but in both your code and my code I get the same error

Run-time error '58':

File already exists

Please Login or Register  to view this content.

Any ideas?

[mike7952]

So say you have a file named _2AAvg Cap Cost_2AQTR - Budget.xlsx and you want to rename it Avg Cap CostQTR - Budget. If your getting that error its because there is a file in that folder already named Avg Cap CostQTR - Budget.

[MissaLissa]

Wow... I'm losing it!!

I looked for the file over and over prior to creating this thread and couldn't for the life of me find it. Looked again and it's staring me right in the face.

Thank you Mike

[mike7952]

MissaLissa,

Sometimes its like that...

Glad you got it straight.