Importing .frm and .bas files using code

mihnea96 · #1 07-25-2017, 07:30 AM

Hi,

i'm trying to make a word document that when opened installs (imports) the macros into the computer, but i've been trying to use the code bellow and kept getting the error "Method 'Import' of object'_VBComponents failed". could you help me out, please?
i've wanted to do this from Excel as i have other installs there as well and it would've been easier to do it from only one file, but it doesn't work.

code:
ActiveDocument.VBProject.VBComponents.Import Environ("SystemDrive") & Environ("HomePath") &...........

thanks in advance!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Importing Pub files into another Pub document	drlynda	Publisher	0	11-20-2014 02:02 PM
Importing .msg files into another PC ?	bill123	Office	2	08-15-2011 09:47 AM
Is there any way of importing Indicators field through code?	Prabhakar	Project	0	04-07-2011 05:50 AM
Importing many vcf files in excel	shiflerg	Excel	0	01-26-2011 09:16 AM
Importing CSV files into Oulook	victoria61485	Outlook	5	12-03-2010 05:33 AM