How to Rename Files In A Folder Using VBA??

[liammoohan]

I have a folder C:\Reporting\A10\

I have an excel sheet which when I run VBA will list all the files in the above folder in column 'A' (see below):

The values in column 'B' are what I need the files to be renamed to and was wondering if this can be done using VBA?

Thanks
Liam

 

[Marc L]

Tried the code provided and it is Debugging (see image):

As it works a treat on my side so you felt into the bad reader trap ‼​

​

As written in post #4 the VBA procedure must be located in the worksheet module (rather than a standard one like 'Module1') …​

 

[liammoohan]

As it works a treat on my side so you felt into the bad reader trap ‼​

​

As written in post #4 the VBA procedure must be located in the worksheet module (rather than a standard one like 'Module1') …​

Thanks Marc L; working now.

I do need some new glasses as my current ones broke last week.

Maybe that will help with the reading in future ?; thanks again

 

[Marc L]

I had myself the same bad reader trap issue with my post #3 !​