I am copying from one workbook to another. This code works fine in Excel 2007. However, it freezes each time in 2013 on the .Close portion.
Any idea as to why this would happen? There is no issue with the path, and this code has been run hundreds of times in the previous version of Excel so it is quite clear that the only cause can be 2013. Thanks in advance.
Any idea as to why this would happen? There is no issue with the path, and this code has been run hundreds of times in the previous version of Excel so it is quite clear that the only cause can be 2013. Thanks in advance.
Code:
' open workbook
Private wkbSource As Workbook
Set wkbSource = Application.Workbooks.Open(workbookImportPath)
' copy stuff
' close workbook (freezes on this line)
wkbSource.Close savechanges:=False
