Hi champs,
I'm extracting reports on which I run a macro; these files always start with getjobid and I currently have to run the macro manually once the file is loaded.
Hence, in order to speed up the process I have been working on a code to check the name of all workbooks that open up, and run this macro if the name of the workbook start with "getjobid", however I am getting a debug with my code and couldn't find a workaround anywhere, hence my post.
I have placed my code below under Thisworkbook within my PERSONAL.XLSB project:
It seemed pretty straightforward to me but won't work.![]()
Please Login or Register to view this content.
I have tested it by entering the below line which said getjobid as expected, however it fails within the code above.
Appreciate any help.![]()
Please Login or Register to view this content.
Cheers,
Fabien
Bookmarks