Vba batch processing

[cheeseyone1]

Hi all ,
I am have some issues batch processing some files . I am, attempting to duplicate macros across multiple files . I have exported modules and imported modules with no problem but the one that stumps me is I want to copy what is coded in "thisworkbook" (private sub workbook open ) to add this code to multiple excel files I have . My goal is to add auto close timer to all existing files in a directory .

any help is appreciated