How to Import Multiple Modules into VBA

In Windows Explorer, select the files you would like to drag into your project. Then simply drag and drop them in to the desired VBA Project.

Here is the tip: Be sure to name the module in the properties before you export it. Otherwise it will default to Module# vs it’s saved name.

image 

 

Thanks to one of my EBSCO students for this question!

Author: Robin E. Hunt

2 thoughts on “How to Import Multiple Modules into VBA

  1. Thank you thank you thank you for this one!!! Saved me HOURS of importing 18 modules one by one into 72 files.

Comments are closed.