Hi again, i got this code from a http://www.cpearson.com/excel/vbe.htm given to me by al, i have a question about this piece of code:
this test for the existance of a module in the workbook its run from. My question is, is there a way to modify it to test for the module in ALL the workbooks i have open (say if for example i had 3 open)? heres the code:
Function ModuleExists(ModuleName As String) As Boolean
On Error Resume Next
ModuleExists = Len( _
ThisWorkbook.VBProject.VBComponents(ModuleName).Name) <> 0
End Function
thanks
this test for the existance of a module in the workbook its run from. My question is, is there a way to modify it to test for the module in ALL the workbooks i have open (say if for example i had 3 open)? heres the code:
Function ModuleExists(ModuleName As String) As Boolean
On Error Resume Next
ModuleExists = Len( _
ThisWorkbook.VBProject.VBComponents(ModuleName).Name) <> 0
End Function
thanks