Hi,
I am trying to copy a range of cells from one sheet of Workbook A to another closed excel workbook B using a macro. The two workbooks are in a different folder.
I have three macros in total that all work fine independently. But once combined it doesn't copy the cells to workbook B
1) Macro1: A recorded macro that copies cell from workbook A and pastes them in Workbook B.
2) Macro2: Simply opens up workbook B
3) Combines the 2 macros from above and is attached to a button in workbookA.

The codes:
Macro1:
Sub Copy_workbookA_To_WorkbookB()
'
' Copy_workbookA_To_WorkbookB Macro
    ActiveWindow.SmallScroll Down:=27
    Range("A47:AD57").Select
    Selection.Copy
    Range("AN51").Select
    Application.CutCopyMode = False
    ActiveCell.FormulaR1C1 = ""
    Range("BA42").Select
End Sub
Macro2:

Sub Open_WorkbookB ()
 
Workbooks.Open Filename:="F:\documents\WorkbookB.xlsm"
 End Sub
Macro3:
Sub Submit_Finished()  
    Call Open_WorkbookB
    
    Call Copy_workbookA_To_WorkbookB
  
End Sub
I have no experience in VB, so any help is much appreciated!

Thank you!