I just downloaded Office 2016 and many of my 2011 Excel workbooks open other workbooks with VBA and use the data in them. They don't work with 2016.
The Workbooks.Open pathname instruction just does't do the job. When I try to record a macro to do that I get blank. What's the new way of doing it?