Need Help to Open File from assigned Folder and Check one condition , Delete and Save.

[Naveed Raza]

Hi Everyone,

I need small help in my written code and i know this will resolved here.

I written a macro in File Checking and deleting workbook and rest all file will be there in assigned folder.

I have some csv files in folder like (Johnxxx, Jessxxx, John25x) and it may be increase or decrease.

what exactly i want here is , macro should open file and check if Range("A3") Empty then close file and delete file from the folder, and if Range("A3") contain some data then close the file and delete "xxx" from file name (means if in workbook "Johnxxx" range(A3) contain some data then "Johnxxx" workbook should close and delete "xxx" from file name "Johnxxx" to "John".

I hope my explanation is understandable.

Thanks in Advance.

[Naveed Raza]

Hi Everyone,

I used Kill for file deleting, i just need code to remove "xxx" from file names.

any help please !

Thanks in advance.

[AlphaFrog]

Try something like this...

Please Login or Register  to view this content.

[Naveed Raza]

Thank you so much sir its work perfectly.

Thank you once again