Hi
I am trying to make a macro to copy + paste from one excel workbook into another + various other things
I have made the macro in a seperate workbook as i am attempting to open up several workbooks and insert the macro and run it.
I have a problem where it is looking for the orignal workbook that i used when recording.
Is there anyway to edit the macro so it goes back to the spreadsheet that you entered the macro into only so that it will work on several spreadsheets?
It is currently doing this
Selection.Copy
Windows("03 2013 Branch Pack Updated TPBP.xls").Activate
I obviously dont want it to try and find this spreadsheet all of the time
Thank you
I am trying to make a macro to copy + paste from one excel workbook into another + various other things
I have made the macro in a seperate workbook as i am attempting to open up several workbooks and insert the macro and run it.
I have a problem where it is looking for the orignal workbook that i used when recording.
Is there anyway to edit the macro so it goes back to the spreadsheet that you entered the macro into only so that it will work on several spreadsheets?
It is currently doing this
Selection.Copy
Windows("03 2013 Branch Pack Updated TPBP.xls").Activate
I obviously dont want it to try and find this spreadsheet all of the time
Thank you