Add additional functionally to an existing macro

[JonnyEnglish]

Hi,
I’d like to add a macro to extract the data from the mission folder into the excel sheet… I was hoping I could find a way to modify one of the existing macros to this end but it’s too technical for me.
If you’re interested in helping me out I’ve included sample data and an example of what I am after in the attachment accompanying this post.

Ok, so I removed the old attachment and set the commandbar’s Temporary argument to true.

hopefully I’ve done this correctly…


Sub AddToCellMenu()
With Application.CommandBars("Cell")
.Reset
.Controls.Add(Type:=msoControlButton, Before:=2, Temporary:=True).Caption = "Update Sheet..."
.Controls("Update Sheet...").OnAction = "LoopAllTxtFilesInFolder"
End With
End Sub

[mikerickson]

WARNING: invasive workbook

Your attachment adds controls to a standard Excel CommandBar (the one you see when you right click a cell). These added controls do not have their Temporary argument set to True.

I.E. The code in your attached file will alter people's Excel application in a way that will persist after closing the file.

Cautious responders should open your file with Macro Disabled.

[JonnyEnglish]

how do i fix that so it's not a problem?

[mikerickson]

When you .Add your command bar control, set the Temporary argument to True. That way the control will persist only until the user closes Excel.