Excel MAC 2011/2016 Updating master workbook from second workbook not working

I have developed a system whereby a user completes a timesheet and saves the file. Then a button in a Master workbook opens the timesheet and imports data into a table in the Master. This works perfectly in Excel 2016 for WINDOWS but, when I try to run it on a Mac (tried both 2011 and 2016), although the timesheet workbook opens, none of the data is updated in the Master workbook.

I've copied a section of the code below which also shows some comments (** CAPS lines) to describe what is happening. No error message is sent and the code completes normally, but it appears that the Master is not "reading" any of the data from the Timesheet workbook.

I'm wondering if this has something to do with the way Mac versions of Excel handle multiple workbooks, but I'm not familiar with Mac so have run out of ideas!

Are there any Mac experts who can shed any light?

Many thanks
Shirley

Please Login or Register  to view this content.

I eventually managed to fix this!

Had to do a "Set Workbooks.Open"

All working now