Dear All
I want to transfer data from the master workbook to another workbook
If the transfer to destination.xlsx is successful
but if transfer to destination.xlsm is unsuccessful
any idea ?
this is my code
I want to transfer data from the master workbook to another workbook
If the transfer to destination.xlsx is successful
but if transfer to destination.xlsm is unsuccessful
any idea ?
this is my code
VBA Code:
Private Sub CommandButton1_Click()
Dim strPath2 As String
Dim wbk As Workbook
strPath2 = "C:\destination.xlsm"
On Error Resume Next
Set wbk = Workbooks.Open(strPath2)
Application.ScreenUpdating = False
Application.DisplayAlerts = False
ThisWorkbook.Worksheets("Master").Range("A1:A30").Copy
wbk.Worksheets("destination").[E15].PasteSpecial Paste:=xlPasteValues
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub