copy a module from one workbook to another via code

[drawworkhome]

i am looking for some guidance on copying a sub routine ("checkrange" in workbook (a)) to the same place in a new workbook i create.
the steps i am looking for is:
1. create a newworkbook (b)--this is up and running
2. copy 2 sheets from another workbook (a)--this is up and running also
3. copy sub routine (checkrange)from workbook a to workbook b
4. carry on with what i am trying to accomplish--yet to be written......

i am a newbie, so not sure what hurdles i need to jump over.
any input is greatly appreciated.
e
ps, found this link and will try and work this:
http://www.cpearson.com/excel/vbe.aspx

[lucas]

I'm short on time but you can check out this thread:

http://www.vbaexpress.com/forum/showthread.php?t=6125&highlight=copy+sub+module

post #7 especially.......You can probably find more by searcing the forum.

[Bob Phillips]

You need to allow Trusted Access to Visual Basic Project to be able to write to the VBE.

The simplest way is to put that sub in a separate module, expoort the module from the one workbook, import it into another, and then kill it.

[drawworkhome]

thank you all.
i will enjoy damaging the wall with my head on this one.
stay tuned....

[drawworkhome]

do i need to set a reference to anything, like vbaproject?

[GTO]

By memory/not tested, but I seem to recall VBIDE being necessary.

[drawworkhome]

man, where does a guy go to learn all this??
first filescriptobject and now this....
is there a book or something that puts this all together?
btw, thanks for the tip gto, hope your staying warm down yonder way.
erik
also, can you have to many references set? maybe take a performance hit from this?

[Bob Phillips]

do i need to set a reference to anything, like vbaproject?

I never do, never have had to.

[Bob Phillips]

man, where does a guy go to learn all this??
first filescriptobject and now this....
is there a book or something that puts this all together?
btw, thanks for the tip gto, hope your staying warm down yonder way.
erik
also, can you have to many references set? maybe take a performance hit from this?

Most of those references are set by default, Excel will load them as it needs them.

[GTO]

Dang it and shame on me. Knew I shoulda checked before opening my big yap.

Sorry about that drawworkhome.

[drawworkhome]

no worries. all part of learning this stuff.
i hope to make this my occupation one day....

[Bob Phillips]

Me too :think:

[lucas]

GTO, don't beat yourself up over that. I do it all the time.

We give the best info we can and if there are better or more correct ways, well thankfully, Bob, Malcolm and others are here.

Usually, the more discussion, the better.

[drawworkhome]

well, for the record, i appreciate all the help. this forum is by far the best i have found. you guys are great and there is always more than one way to skin a cat.....
thanks!!!