Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have written code to open a series of files and change the various
aspects of the tabs in those files. I've started writing code in a file called "Revisor" which opens the target files and makes changes. Now I need to modify the code in the target files. I found Chip Pearson's site and found a Sub to copy Sheet modules and the ThisWorkbook module from one file to another, and successfully modified it to fit my application: the modifiying code is in the Revisor file, which opens a Master file to copy "from" and the Target files to copy "to". My hurdle at this moment is copying Module1. Mr. Pearson's site offers a function to perform this, but I cannot get this to work for me after several hours of working on it. I am not familiar enough with functions to incorporate this into the code I've written, and I can't quite follow the "Copy A Module From One Project To Another" logic at CPearson.com- for instance, I don't see any assignment that distinguishes one file as FromVBProject and another as ToVBProject. Anyone used this, or have a moment to point me in the right direction? Thanks And as a final note, I am stupefied and amazed by the volume of information at CPearson.com- my hat is off to you, sir! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calling VBA Function | Excel Programming | |||
Calling DLL function | Excel Programming | |||
Help with calling a function | Excel Programming | |||
calling a function | Excel Programming | |||
calling a function | Excel Programming |