'----------------------------------------------------------------
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