Userform to edit macro?

Hi,

I had a little search but couldn't find anything on the subject.
I'm wondering if its possible to create a userform that can update code in a macro?

Specifically, I have a macro that updates external data but the link for this external data changes weekly. So rather than have to edit the macro manually, the userform will do it when requested.

Here is an example of the code, with the sections required to be changed highlighted in red:

ActiveWorkbook.UpdateLink Name:="T:\Filepath\Data\week 36\file wk36.xlsx", Type:= _
xlExcelLinks

Thanks in advance for any time or assistance with this.

Hi,

Thanks for the replies.
Both are excellent ideas and I will try them both out to see which fits better.
The general idea is to make the weekly update process easy enough for anyone to do.
Unfortunately, that means 'really' computer illiterate people in some cases.

Many thanks.