Changing file paths in macro automatically

HI,

I have a file named input1.xlsm in folder C:\values\extra\input\input1\input1.xlsm.

And there is a command button named "SUBMIT" in cell "E6" of "sheet1".

I would like to copy-paste the file "input1.xlsm" to a different folder, which is "C:\values\extra\input\input2\input1.xlsm"

But the problem is that the file paths that are present in the command button "SUBMIT" wont't change when i copy-paste "input1.xlsm to the folder input2.

Is there a way so, that the filepaths in the macro also change after COPY-PASTE?

cheers

Hi,

Set myData1 = Workbooks.Open("C:\values\extra\input\input1\VALUES1.xlsm")
myData1.Save
myData1.Close


is required to be changed to :

Set myData1 = Workbooks.Open("C:\values\extra\input\input2\VALUES1.xlsm")
myData1.Save
myData1.Close

after pasting the file inpu1.xlsm to folder input2.

But it remains constant, any ideas about the problem?

thanks