I am trying to run a Macro on a different WorkBook.

When I "HARD CODE" the name of the WorkBook into the Macro it works, but how can I get it to work when I assign the name of the WorkBook to a variable.


The name of the workbook contains spaces.
This works: Application.Run ("'Search Database 2025 test.xls'!RedFont")

This is the bit of code that's creating the problem when I try to use it with a variable

    ol2 = ActiveWorkbook.Name
    Workbooks(ol2).Application.Run ("!RedFont")