Copy Data from external workbook with external macro

[HunterA]

Hello, thanks in advance for any help! Im newish to VBA.

I am trying to fix a mistake that I made from a master workbook into multiple save as workbooks.

The formulas I wrote in the original master were incorrect from range (A36:E37)

I wrote a VBA in my personal book that attempts to unlock the sheet, clear the data, replace the data from an external sheet, protect the sheet, save, and close.

I am using thisworkbook, and activeworkbook but it refrences my personal workbook in that case, not the one I want to.

Example, Open workbook 1 (corrected master) and 2. Copy range data from 1 to 2, save 2, close 2, repeat with 3-100

' fixprimalrecipe Macro
'

'
Range("A36:E37").Select
ActiveSheet.Unprotect
Selection.ClearContents
Windows("PRIMAL ALCHEMY RECIPE COSTING CARD.xls").Activate
Range("A36:E37").Select
Selection.Copy
ActiveWorkbook.Activate
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
ActiveWorkbook.Save
End Sub


Any help is again, much appreciated!

 

[HunterA]

possibly this is a more concise way of explaining this:

I have a workbook A that I use as a template for spinoff workbooks B, C, D, wateverworkbook name is chosen

I made an error in formulas range A36:E37. I need to correct it in all the subsequently created workbooks, which can have any random name

I want to open the corrected master workbook A, and copy the range from A to whateverworkbookname

Every time I use thisworkbook refrerence, it pastes the data to my personal macro workbook, same thing with activeworkbook.

I'm sure there's a simple solution, (like assigning a variable to the freshly opened workbook that needs fixing?) but I don't know how to do that.

Help is much appreciated!

Also of note, I am planning on manually opening the whaverworkbookname, then VBA unprotecting the sheet, copy paste function, protecting the sheet, saving, and closing the whateverworkbookname book when the macro completes, to be repeated with the rest of the incorrect workbooks.

I don't want to put the macro into the source or target workbooks if possible. it could be in the source if it needed to be.

If there is a smarter way to do this (which is probably way over my head) like applying a macro to all workbooks in a folder for instance, I would be interested in a point in the right direction to learn about it.