Problems with looping macro through specific folder

Hi, i have a macro to clear contents on all sheets on Col A.

Please Login or Register  to view this content.

this macro works when i place it in a specifc workbook to run it. However when i try calling it using this macro to loop through all workbooks in specific folder it doesn't work. The looping macro is as below. Can someone show me where i went wrong? Master represents the workbook which the looping macro is running from and Book1 and Book2 are the files that i want to clear contents with.

Please Login or Register  to view this content.

Hi i tried your macro but there seems to be an error

Please Login or Register  to view this content.

However essentially i want to learn how to use a macro in a master workbook to loop pre-exisiting macros by call the sub procs, is there anyway to work around it this way?

Hi thanks for your help i think the macro works but i the macro does not save the results of the clearcontents how do i add that?

Thanks the code now works, is there a way to code so that i can just call sub procedures because i still have other macros i want to loop through folders?

Please Login or Register  to view this content.

something like this? where clear contents is

Please Login or Register  to view this content.

because i still have other macros to run and i am not very proficient at macros hence i want a general macro that links several subprocedures together, instead of prompting the forum boards continually. Thanks modred and dave

Hi, i have tried again using call sub method however the is an error on the sub c()

Please Login or Register  to view this content.

can someone clarify why there is an error when calling this sub proc?

actually i have other sub sub procs such as trim all cells and also adding a date column based on a cell reference that is why i am more comfortable using a looping macro through folder and then calling sub procs thanks a lot