Macro Help

[02rj03]

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

 

[02rj03]

I managed to come up with a solution

so you can lock this

thanks