Insert Spreadsheet Macro - Works in 2010 but not 2016

Question

I have a VBA macro which copies a summary tab from one workbook to another. It works fine in 2010, but not for our associates who've upgraded from 2010 to 2016. The macro doesn't error out - it just doesn't do anything at all. Does anyone have any suggestions on what might be different with 2016? Thank you! Sub Analyst_Summary_macro() ActiveWorkbook.Save Dim MyPath As String, MyCompletePath As String MyCompletePath = ActiveWorkbook.FullName Dim wkbSource As Workbook Dim wkbDest As Workbook Dim shtToCopy As Worksheet Set wkbSource = Workbooks.Open("C:\Users\n0079864\Desktop\Analyst_Summary.xlsx") Set shtToCopy = wkbSource.Sheets("Analyst_Summary") Set wkbDest = Workbooks.Open(MyCompletePath) shtToCopy.Copy wkbDest.Sheets(1) Workbooks("Analyst_Summary.xlsx").Close False Application.ScreenUpdating = False End Sub JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

Are you copying into the workbook which has the code, or some other workbook? Using ActiveWorkbook.FullName to open another workbook seems odd, and may lead to problems. Try the following changes: Sub Analyst_Summary_macro() Dim wkbDest As Workbook Set wkbDest = ActiveWorkbook 'or ThisWorkbook? wkbDest.Save With Workbooks.Open("C:\Users\n0079864\Desktop\Analyst_Summary.xlsx") .Sheets("Analyst_Summary").Copy wkbDest.Sheets(1) .Close False End with End Sub