Correct Vba By Macro

[mprice40ca]

I have a huge quantity of workbooks that access another workbook and use a "modular" macro to print specic pages inside a work book, check and correct some other links...

anyway the location of the workbook moved due to IT issues.

is there a way to write a macro to change the VBA from:

Private Sub CommandButton2_Click()
Application.Run ("'G:\New G Drive\Data\MIR_History\History_Sheet.XLS'!PrintMir")
End Sub

To:

Private Sub CommandButton2_Click()
Application.Run ("'G:\Data\MIR_History\History_Sheet.XLS'!PrintMir")
End Sub

So that the users can make there own corrections.

Moderator's note: Please review forum rules. Rule #3 requires CODE tags around VBA code. I have added them since it's your first post. --6SJ