How to set Entire Vba Project to variable

How to set Entire Vba Project to variable

Hi Dear support!

I am trying write more complicated function but i have a problem  with find VBA project, for example (easy example to show problem)

what i should set in   Set vbProj = ?
for example in Excel i will set = ThisWorkbook.VBProject

Sub LookingForStringInEntire_VBA_project()
    Dim vbProj As VBProject
    Dim vbComp As VBComponent
    Dim strToFind As String
    Dim strModuleName As String
    Dim strModuleCode As String
    Dim test As Variant
    Dim i As Long
    
   
    
    ' Str to find
    strToFind = "my string"
    
    ' set reference to project VBA
    Set vbProj = "What i should set here"
    
    ' look every module in set project
    For Each vbComp In vbProj.VBComponents
        ' check if component is a module
        If vbComp.Type = vbext_ct_StdModule Then
            strModuleName = vbComp.Name
            ' set module's code
            strModuleCode = vbComp.CodeModule.Lines(1, vbComp.CodeModule.CountOfLines)
            
            ' looking for string which you set
            If InStr(1, strModuleCode, strToFind, vbTextCompare) > 0 Then
              MsgBox "ok i found"
            End If
        End If
    Next vbComp
    
    ' clean memory
    Set vbProj = Nothing
    Set vbComp = Nothing
End Sub


Thanks!

    Disclaimer

    This document governs the use of our Community Forum. By registering and using the platform, you accept these conditions.

    The COPA-DATA Community Forum serves to encourage the exchange of information and experience about the zenon software between forum users respectively zenon users.

    Please mind that any published information on the Community Forum is the subjective opinion and view based on the experience and the level of knowledge of the author. COPA-DATA does not overtake any responsibility for the content and the accuracy of the shared information.

    Users of the Community Forum are encouraged to share only well-founded experiences and to point out any risks associated with the implementation of proposed solutions to problems. COPA-DATA at its absolute discretion, reserves the right to moderate the forum. In this connection COPA-DATA may remove any information containing false facts, potentially dangerous solutions, bad language or content that may insult, degrade or discriminate others. COPA-DATA may block a non-complying user from forum access if the user violated this provision.

    COPA-DATA reserves the right to change this document from time to time at own discretion.


    Ing. Punzenberger COPA-DATA GmbH
    Karolingerstraße 7b · 5020 Salzburg · Austria
    www.copadata.com