macro to delete specified files in a folder

[Howardc1001]

I have tried to write code to delete specified files in a folder C:\data analysis for eg BR1 Period 4 Sales Ledger.xls, BR2 period 5 Sales ledger.xls etc


I have specified the folder in Col A , whether to include sub-folders in Col B and have shown part of the file name using a wildcard character in Col C


I get a compile error : User defined type not specified

Please Login or Register  to view this content.

It would be appreciated if someone can test my code and amend it to suit my needs

[YasserKhalil]

From Tools >> References >> Check the option 'Microsoft scripting runtime'

[Howardc1001]

thanks for the help. I have done tht and macro runs but not files are deleted in the folder for eg BR1 period 4 Sales data.xls, BR1 period 5 Sales data.xls etc


It would be appreciated if you could amend my code so that it deletes the files in col C containing a wildcard character

[daboho]

coba ini

Please Login or Register  to view this content.

[Howardc1001]

Thanks for help. The files in the folder for period 4, Period 5, period 6, period 6 and period 8 which is in C2:C7 , which are csv files are not being deleted

See one of the sample csv file as well as the file using your code


Please test and amend code

[Howardc1001]

hi guys


It would be appreciated if you could assist me in amending the code as the text in Col C containing part o the file name, is not being deleted

[bakerman2]

Remove the wildcard characters in Column C.
Then for starters.

Please Login or Register  to view this content.

[Howardc1001]

thanks for the help. Your code works perfectly

[bakerman2]

Glad to assist and thanks for rep+.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.