Mark A Matte
markamatte at hotmail.com
Fri Mar 28 12:52:39 CDT 2008
Hello All, I am using the code below to loop through the Modules and find stuff. It always points to the current db. Is there any way to point this to a different database...if so anyone know the syntax? Thanks Again, Mark A. Matte *************** For Each vbComp In VBE.VBProjects(1).VBComponents With vbComp StartLine = 1 StartColumn = 1 EndLine = vbComp.CodeModule.CountOfLines EndColumn = 60 strCode = .CodeModule.Lines(1, .CodeModule.CountOfLines) ************* _________________________________________________________________ Test your Star IQ http://club.live.com/red_carpet_reveal.aspx?icid=redcarpet_HMTAGMAR