Can VBA code be programmed to change itself?

[Kelvin Stott]

Given that VBA code can be programmed to make virtually any changes in Excel, Word, etc., I was wondering if VBA code can be written to change itself, for example, by deleting itself if certain conditions are met, for security purposes?

 

[NeonRedSharpie]

Sorry if this is an old thread, but I'm actually ruminating on that same question myself:

Would it be possible for the VBA code, instead of changing itself in a destructive manner, to change itself in a constructive manner? Such as expanding its own ranges or including new sheets in a coded query?

I'm going to start an experiment where a spreadsheet queries, returns results, and develops new queries. And i'm curious how the VBA might develop new sheets and include those sheets in the next query.

Any suggestions?

Use variables instead of ANYTHING absolute. Then you shouldn't have any problems.

For a dynamic range:

Sub dynamicRange()

    Dim startRow As Integer
    Dim endRow As Long
    
    Dim startCol As Integer
    Dim endCol As Long
    
    Dim rng As Range
    
    startRow = 1
    startCol = 1
    endRow = Cells(Rows.Count, "A").End(xlUp)
    endCol = Cells(1, Columns.Count).End(xlToLeft).column
    
    
    Set rng = Range(Cells(startRow, startCol), Cells(endRow, endCol))
    
    For x = startRow To endRow
        'CODE
    Next x


End Sub

Dynamic sheets:

Sub dynamicSheets()

    For x = 1 To Sheets.Count
        'code
    Next x


End Sub

 

[hwkeyser]

Use variables instead of ANYTHING absolute. Then you shouldn't have any problems.

Thank you!

It may be a while before I get anywhere with this, but I'll try to come back and let you know how it's going!

-H