Replace Code Programmatically
 

Is it possible to replace code from one a module programmatically?
Specifically, can there be a process that opens a workbook and then replaces
a module from another workbook. Also .. can a compile be performed?

Thanks in advance,

Stewart Rogers

Replace Code Programmatically
 

Stewart,

Take a look at http://www.cpearson.com/excel/vbe.htm



--

HTH

RP
(remove nothere from the email address if mailing direct)


"Datasort" wrote in message
...

Is it possible to replace code from one a module programmatically?
Specifically, can there be a process that opens a workbook and then
replaces
a module from another workbook. Also .. can a compile be performed?

Thanks in advance,

Stewart Rogers

Replace Code Programmatically
 

Wow, I hope not. Isn't that what viruses do?

"Datasort" wrote:


Is it possible to replace code from one a module programmatically?
Specifically, can there be a process that opens a workbook and then replaces
a module from another workbook. Also .. can a compile be performed?

Thanks in advance,

Stewart Rogers

Replace Code Programmatically
 

Yes, but viruses are usually introduced by scripting languages, which is
exactly what VBA is.

If you don't trust it, don't open it, or disable macros.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"T Kirtley" wrote in message
...
Wow, I hope not. Isn't that what viruses do?

"Datasort" wrote:


Is it possible to replace code from one a module programmatically?
Specifically, can there be a process that opens a workbook and then
replaces
a module from another workbook. Also .. can a compile be performed?

Thanks in advance,

Stewart Rogers