Is it possible to copy a code module using VBA?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I hope someone can help me. I am using VBA in Excel XP with Win 2000

I know that you can reference "extensibility" to write lines to, and edit, a code module

BUT, can you simply copy an entire module from one file to another using VBA? (as though you did a drag and drop in the VBE itself

If so, please respond with your example code, I can't figure it out...thanks much in advance.
 
You can export the module to a file, and then import that file in
to another project. See www.cpearson.com/excel/vbe.htm for more
details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


quartz said:
Hello, I hope someone can help me. I am using VBA in Excel XP with Win 2000.

I know that you can reference "extensibility" to write lines to, and edit, a code module.

BUT, can you simply copy an entire module from one file to
Click to expand...
another using VBA? (as though you did a drag and drop in the VBE
itself)
If so, please respond with your example code, I can't figure it
Click to expand...
out...thanks much in advance.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

?Module code copy 2
Excel 2003 - VBA to get a list of Module names in the project 4
Use VBA to create new sheet with event handlers in sheet's code 2
Delete all code in VBA module - error? 2
Technique for switching to the VBE 16
Possible to do a search/replace in the IDE Code window with VBA? 7
how to store a macro to be available to all workbooks 2
Removing a module using VBA 4

Back
Top