Microsoft Office Forums - View Single Post - [Solved] Importing .frm and .bas files using code

Thread: [Solved] Importing .frm and .bas files using code

View Single Post

Old

07-25-2017, 07:56 AM

gmaxey

gmaxey is offline

gmaxey uses Windows 7 32bit

Windows 7 32bit gmaxey uses Office 2016

gmaxey uses Office 2016

Office 2016

Expert

Join Date: May 2010

Location: Brasstown, NC

Posts: 1,429

gmaxey is a jewel in the rough

gmaxey is a jewel in the rough

gmaxey is a jewel in the rough

gmaxey is a jewel in the rough

Default

Must be your path statement

This works for a module in the active documents parent folder:

Code:

Sub Document_New()
 ActiveDocument.VBProject.VBComponents.Import ThisDocument.Path & "\Module1.bas"
End Sub

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

Reply With Quote