I'm working in excel 2010.
I have a workbook, called Original that opens other temporary workbooks. It copies data from these temporary workbooks into a master tab and then closes them leaving the original workbook open.
If the temporary workbooks aren't shared, the code runs fine. If they are shared, I get an automation error and the code stops, doesn't go into debug just stops.
Cant post any of the existing code, its a work thing and I'm not in work today.
I haven't been able to find any info about why this might happen, is this a known issue or with shared files? Some things I've read say that sharing of workbooks isn't very well implemented in excel.
Is there some code that will check to see if the temporary workbook is shared, if it is turn sharing off when it opens the file and back on when it closes?