devxlogo

Sharing Files Between VB and VBA

Sharing Files Between VB and VBA

You can easily share files such as standard code, form, and class modules (BAS, FRM, and CLS files, respectively) between VB and VBA by using the appropriate menu commands. Within VB, select Project, then Add File… to import the desired file into a VB project. No action is necessary to export a VB file from a project because the files are maintained separately in Windows. Within VBA, select Import, then File… from the VB Editor menu, or right-click on a folder in the Project Explorer and select Import File… from the popup menu. Because these files are stored inside the VBA application’s file, such as in an Excel Workbook, you must export these files to a folder before another VB project can import them. To export a file from within VBA, right-click on the file in the Project Explorer and select Export File… from the popup menu. You will then see a prompt to select the folder where you want to put the file.

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist