need recorded macro to copy from whatever workbook i currently have open and active rather than specific named workbook. without Dim objects or...

[blaineSpartan]

or Set variables. heres what i mean, heres the recorded macro script, just the first bits,
Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+g
'
Range("C5").Select
Windows("LinimarCavity7VarianceReport.xlsx").Activate
Rows("10:10").Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
Windows("24042513_PPAP-RDS_CAA-R03_0983.xlsx").Activate
Selection.Copy
Windows("LinimarCavity7VarianceReport.xlsx").Activate
Range("A10").Select
ActiveSheet.Paste
Windows("24042513_PPAP-RDS_CAA-R03_0983.xlsx").Activate
Range("C8").Select
Application.CutCopyMode = False
Selection.Copy
Windows("LinimarCavity7VarianceReport.xlsx").Activate
Range("B10").Select
ActiveSheet.Paste

this is just a recorded macro so it doesn't have any objects or variables i think?
where in the code it says "Windows("24042513_PPAP-RDS_CAA-R03_0983.xlsx").Activate"
what words or syntax do i need to replace ("24042513_PPAP-RDS_CAA-R03_0983.xlsx") with so that instead of copying from that specific workbook, it will copy from the location of the specific workbook i have open?

 

[Anthony47]

If you remove the line Windows("LinimarCavity7VarianceReport.xlsx").Activate then the instruction Rows("10:10").Select will select that line on the Active sheet of the Active workbook

Unfortunately your description is weak, not the recorded code give a fair idea of what you wish to do, so I am not able to suggest a complete macro