i have this:
Application.Run ("'L:\database\lcmsmacro\macro1.xlsm'!macro_name")
why should i use the single quotes? does it not recognize the backslash?
views:
33answers:
1
+2
A:
I believe it's for consistency.
Single quotes are necessary when the path contains spaces ot exclamation marks, so to make things more consistent and simple, the quotes are required every time.
GSerg
2010-05-10 20:56:35
Thanks for solving a problem that had me banging my head against the wall. This isn't made clear in the Excel 2003 help or in anything I found on MSDN!
nekomatic
2010-10-26 12:10:13