Is it possible to copy a code module using VBA?
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.
|