I am trying to use personal.xlsb macros to copy ranges between two workbook.
The source workbook "Master Costing 2016 ver (f).xlsx" is static and the name will not change
The destination workbook's name will change based on the project.
The Macros are located in personal.xlsb
When I run the macro from the destination workbook it writes to the personal.xlsb sheet1 and not the destination workbook. If I hardcode the destination workbook name it works just fine.
Any help is greatly appreciated.
Below is the code:
Sub ReImaging_License()
'
' ReImaging_License Macro
'
'
Sheets("Parts List").Select
Windows("Master Costing 2016 ver(f).xlsx").Activate
Sheets("Virtual Software").Select
Range("A7:K8").Select
Selection.Copy
ThisWorkbook.Activate
' Windows("Test Target.xlsm").Activate
Range("A" & Rows.Count).End(xlUp).Offset(1).Select
ActiveSheet.Paste
Sheets("Select_Items").Select
End Sub
The source workbook "Master Costing 2016 ver (f).xlsx" is static and the name will not change
The destination workbook's name will change based on the project.
The Macros are located in personal.xlsb
When I run the macro from the destination workbook it writes to the personal.xlsb sheet1 and not the destination workbook. If I hardcode the destination workbook name it works just fine.
Any help is greatly appreciated.
Below is the code:
Sub ReImaging_License()
'
' ReImaging_License Macro
'
'
Sheets("Parts List").Select
Windows("Master Costing 2016 ver(f).xlsx").Activate
Sheets("Virtual Software").Select
Range("A7:K8").Select
Selection.Copy
ThisWorkbook.Activate
' Windows("Test Target.xlsm").Activate
Range("A" & Rows.Count).End(xlUp).Offset(1).Select
ActiveSheet.Paste
Sheets("Select_Items").Select
End Sub