vba to add macro to 'thisworkbook' object?

]-[ /-\ \/\/ /-\ | | /-\ · Feb 21st, 2002, 01:02 PM

I have seen a method of inserting a module with macro code into other workbooks using vba. I would like to know if it is possible to insert just macro code into the 'thisworkbook' object of other workbooks using vba. Can this be done?

Aloha!

NateO · Feb 21st, 2002, 01:18 PM

Aloha! Chip covers a variety of subjects along these lines:

http://www.cpearson.com/excel/vbe.htm

Cheers, Nate

]-[ /-\ \/\/ /-\ | | /-\ · Feb 21st, 2002, 04:54 PM

...YES, mahalo much Nate! Exactly what I was looking for.

Aloha!

NateO · Feb 21st, 2002, 04:56 PM

Bodacious. Hang Loose,

Nate

Feb 21st, 2002, 01:02 PM	#1
]-[ /-\ \/\/ /-\ \| \| /-\ New Member Join Date: Feb 2002 Location: ]-[ /-\ \/\/ /-\ \| \| ~~~@\|_()]-[/-\!!! Posts: 48	I have seen a method of inserting a module with macro code into other workbooks using vba. I would like to know if it is possible to insert just macro code into the 'thisworkbook' object of other workbooks using vba. Can this be done? Aloha!
$]-[ /-\ \/\/ /-\ \| \| /-\ is offline$

Feb 21st, 2002, 04:54 PM	#3
]-[ /-\ \/\/ /-\ \| \| /-\ New Member Join Date: Feb 2002 Location: ]-[ /-\ \/\/ /-\ \| \| ~~~@\|_()]-[/-\!!! Posts: 48	...YES, mahalo much Nate! Exactly what I was looking for. Aloha!
$]-[ /-\ \/\/ /-\ \| \| /-\ is offline$

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

Feb 21st, 2002, 01:18 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Aloha! Chip covers a variety of subjects along these lines: http://www.cpearson.com/excel/vbe.htm Cheers, Nate

Feb 21st, 2002, 04:56 PM	#4
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Bodacious. Hang Loose, Nate