Why should I use single quotes for application.run in excel?

I have it:

Application.Run ("'L:\database\lcmsmacro\macro1.xlsm'!macro_name")  

      

why should i use single quotes? doesn't it recognize backslashes?

+2


a source to share


1 answer


I believe that's for consistency.



Single quotes are needed when the path contains spaces from exclamation marks, so to make things more consistent and simpler, the quotes are required every time.

+3


a source







All Articles