| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace module with code
I want to replace a current module in a workbook with a updated module of th same name. More or less like a patch. Can this be done using code. I've looked through the threads and do not see anything that directly relates to using code to replace the module. M -- Michael Wise ------------------------------------------------------------------------ Michael Wise's Profile: http://www.excelforum.com/member.php...fo&userid=6998 View this thread: http://www.excelforum.com/showthread...hreadid=571347 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Replace module with code
Hi Michael,
See Chip Pearson's programming to the VBE page at: http://www.cpearson.com/excel/vbe.htm --- Regards, Norman "Michael Wise" wrote in message news:Michael.Wise.2cj543_1155558608.2199@excelforu m-nospam.com... I want to replace a current module in a workbook with a updated module of th same name. More or less like a patch. Can this be done using code. I've looked through the threads and do not see anything that directly relates to using code to replace the module. M -- Michael Wise ------------------------------------------------------------------------ Michael Wise's Profile: http://www.excelforum.com/member.php...fo&userid=6998 View this thread: http://www.excelforum.com/showthread...hreadid=571347 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Replace module with code
'----------------------------------------------------------------
Function UpdateModule() '---------------------------------------------------------------- Dim vbMod As Object Set vbMod = ThisWorkbook.VBProject.VBComponents("mTest") ThisWorkbook.VBProject.VBComponents.Remove vbMod ThisWorkbook.VBProject.VBComponents.Import _ Filename:="C:\mTest.bas" End Function -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Michael Wise" wrote in message news:Michael.Wise.2cj543_1155558608.2199@excelforu m-nospam.com... I want to replace a current module in a workbook with a updated module of th same name. More or less like a patch. Can this be done using code. I've looked through the threads and do not see anything that directly relates to using code to replace the module. M -- Michael Wise ------------------------------------------------------------------------ Michael Wise's Profile: http://www.excelforum.com/member.php...fo&userid=6998 View this thread: http://www.excelforum.com/showthread...hreadid=571347 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Replace module with code
Also, include this at the start of the code module
Const vbext_pk_Proc = 0 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Michael Wise" wrote in message news:Michael.Wise.2cj543_1155558608.2199@excelforu m-nospam.com... I want to replace a current module in a workbook with a updated module of th same name. More or less like a patch. Can this be done using code. I've looked through the threads and do not see anything that directly relates to using code to replace the module. M -- Michael Wise ------------------------------------------------------------------------ Michael Wise's Profile: http://www.excelforum.com/member.php...fo&userid=6998 View this thread: http://www.excelforum.com/showthread...hreadid=571347 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Replace module with code
that site is helpful. i used it to create a single checkbox on a form, i use for
a menu, to toggle auto open on and of. -- Gary "Norman Jones" wrote in message ... Hi Michael, See Chip Pearson's programming to the VBE page at: http://www.cpearson.com/excel/vbe.htm --- Regards, Norman "Michael Wise" wrote in message news:Michael.Wise.2cj543_1155558608.2199@excelforu m-nospam.com... I want to replace a current module in a workbook with a updated module of th same name. More or less like a patch. Can this be done using code. I've looked through the threads and do not see anything that directly relates to using code to replace the module. M -- Michael Wise ------------------------------------------------------------------------ Michael Wise's Profile: http://www.excelforum.com/member.php...fo&userid=6998 View this thread: http://www.excelforum.com/showthread...hreadid=571347 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Replace module with code
Bob- I realize this is an old thread, but I'm catching up- I've had trouble
using code to update modules (an ongoing task) and I haven't seen this line of code before. What does it do? Thanks! Keith "Bob Phillips" wrote in message ... Also, include this at the start of the code module Const vbext_pk_Proc = 0 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Michael Wise" wrote in message news:Michael.Wise.2cj543_1155558608.2199@excelforu m-nospam.com... I want to replace a current module in a workbook with a updated module of th same name. More or less like a patch. Can this be done using code. I've looked through the threads and do not see anything that directly relates to using code to replace the module. M -- Michael Wise ------------------------------------------------------------------------ Michael Wise's Profile: http://www.excelforum.com/member.php...fo&userid=6998 View this thread: http://www.excelforum.com/showthread...hreadid=571347 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
| copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
| Run worksheet module code from workbook module? | Excel Programming | |||
| Macro to replace a VBA module? | Excel Programming | |||
| Create a newworksheet with VBA code and put VBA code in the new worksheet module | Excel Programming | |||
![Michael Wise[_38_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
