If workbook name contains string then run macro

[fabien1]

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:

Please Login or Register  to view this content.

It seemed pretty straightforward to me but won't work.

I have tested it by entering the below line which said getjobid as expected, however it fails within the code above.

Please Login or Register  to view this content.

Appreciate any help.
Cheers,
Fabien

[YasserKhalil]

There's extra space at the text "getjobid " .. Try removing that extra space

[fabien1]

Hi,
Thanks for your quick response.
Unfortunately that didn't do the trick. :-(

[YasserKhalil]

I have placed my code below under Thisworkbook within my PERSONAL.XLSB project:

Why don't you use the code for the active workbook module?

[fabien1]

Because the active workbook changes everytime i open this getjobid file.

Does it make sense?

[YasserKhalil]

But I don't think in this case the code would be put in thisworkbook module for PERSONAL.XLSB ...

[fabien1]

Where do you suggest I place the code?

I have tried placing it into the 'Sheet1' as well as 'Module1' and it didn't run.

[xlnitwit]

Hi,

If you want to check any workbook that opens, you need an application event. See Chip Pearson's site.

[fabien1]

Ok thanks, I got it working.
For those who might be interested, find the code below:

Please Login or Register  to view this content.

[YasserKhalil]

Great. Glad you have solved it