How to handle an error of Name function:confused:

[SHIR0206]

Please advise - I wrote a code in VBA that iterates through files in certain directory, rename them, and write the status to Excel. I would like to edit the code so that if the command Name returns error (For example if NewFileName already exists), then the parameter status would be "Fail", and continue to the next iteration. Could anyone help me how to do so?

Please Login or Register  to view this content.

[Keebellah]

Hi, you can use the DIR command to see if the file exists

Please Login or Register  to view this content.

Hope this helps a little

[SHIR0206]

thanks ))))