开发者

why should i use single quotes for application.run in excel?

开发者 https://www.devze.com 2022-12-30 07:21 出处:网络
i have this: Application.Run (\"\'L:\\database\\lcmsmacro\\macro1.xlsm开发者_C百科\'!macro_name\")

i have this:

Application.Run ("'L:\database\lcmsmacro\macro1.xlsm开发者_C百科'!macro_name")  

why should i use the single quotes? does it not recognize the backslash?


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号