Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 50
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 82
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If statement to replace #VALUE! code jeannie v Excel Worksheet Functions 8 June 27th 07 03:53 AM
Replace Symbol "Code(63)" Andri Excel Worksheet Functions 4 February 20th 05 09:17 AM
How to programmatically access sheets in a workbook by code name Bing Excel Programming 1 December 24th 04 11:44 PM
Excel VBA - How do I programmatically change source code in another file? Lisa Norgaard Excel Programming 1 July 14th 04 04:09 PM
how to add code programmatically to a macro for a button Tina Excel Programming 0 August 26th 03 03:30 AM


All times are GMT +1. The time now is 12:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"