Where can I find the procedure called from this Excel VBA Application.Run statement?
I'm working with开发者_运维知识库 an Excel VBA "Sub" that contains a statement like:
Application.Run ("Menu_SomeProcedure")
which is calling some code or functionality which I need to inspect but I'm unable to find the implementation of "Menu_SomeProcedure" anywhere in the VBA module code. Where should I look to find it? I am using Microsoft Office Excel 2003.
It could be coming from an add-in.
Look for any referenced add-ins to your app: Tools/Add-Ins from the file menu.
I think you can do this in the VBA IDE as well. There is an "Add-Ins" option available in 2007...I would think one exists in 2003.
Lastly, you could click "Tools/References" in the IDE to check for any peculiar DLLs references.
精彩评论