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!
Bookmarks