Quote Originally Posted by simora View Post
Paul_Hossler:

A couple of issues.

When the filename that you're calling from another workbook contains spaces, you come up with these issues if you're trying to use/call that workbook by referencing its Variable name from another Workbook.
Excel VBA APPARENTLY does NOT allow you to just do what you were suggesting.

That being said, I would like to see how others have gotten around this in addition to what jindon provided, which turned out to be a workable solution.

Thanks for your input.

I know that. I was just saying that this ...

    ol2 = ActiveWorkbook.Name 
  Workbooks(ol2).Application.Run ("!RedFont")
... seems to be running a macro IN the ActiveWorkbook

Running macro ON the Activeworkbook that in a non-Activeworkbook is different