Visual basic for applications reference file name

Visual Basic definitions. Provides a glossary of definitions to help you understand concepts presented in this documentation. Visual Basic add-in model. Describes how to customize the Visual Basic editor, and provides documentation for the object model that enables you to extend the environment.

User Interface Help. Describes user interface elements of the Visual Basic Editor, such as menus and commands, dialog boxes, windows, and toolbars. The error messages section contains common causes and solutions for any issues you may be having. Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

Skip to main content. Type refme. Because your security level is set to Medium, you will be asked whether you want to enable or disable macros in this document. Click Enable Macros. NoteThis behavior does not occur in Word Click OK to the following compile error message:. You should be in Break mode there is a yellow band across the Sub line. On the Run menu, click Reset to return to Design mode.

On the Tools menu, click References to display the References dialog box. You see that Refme. This library contains objects that refer to the VBA projects. Before you click OK, you must verify that the new reference is added above the "missing" reference.

Click the arrow several times to change the priority, move the new reference above the "missing" reference, and then click OK. In the module, create a new sub procedure named "CheckReference", and then write the following code:. Run the CheckReference sub procedure. The name and location of the file is displayed in the Immediate Window. This section describes how to programmatically remove and reinstate a reference.

To remove a missing reference:. In the CheckReference sub procedure, change the Debug. Print statement as follows. This removes any missing references from your project:. Verify that the reference was removed in the References dialog box on the Tools menu, click References. Verify that the reference to Refme. You can view references in Project Explorer or when you click References on the Tools menu. If you make references to an application's native file, you should keep the native file extension.

Otherwise, you may experience problems when you use the reference. To see these problems, try to make a reference to the Refme. If you are working with a registered component, you can add a GUID reference to your project.

Write code to verify that the reference exists. Write code to remove an incorrect reference. Write code to add the reference back.

Click OK. In the left pane, click Macro Settings. If you want to access functions from it, you could simply use platform invoke to access them. But what methods from this DLL you want to use? What exactly do you try to do in your application? Therefore, I am using the following code:.

Maybe you want to check out Ado. Just ignore Linq and Entity Framework and such stuff. No this code works, it has been tried and tested. It stops at the line "aCatalog. Procedures QueryName. In order to get this reference, what DLL s or procedures, or files, or extentions etc do I need in order to have this reference in VB.

Ask a question. Quick access. Search related threads. Remove From My Forums.