I have a VBA routine that generates about 30 Excel Reports from a single large input Excel workbook. The routine has been developed on Windows PC’s over a couple of years, using Office 2007 and later Office 2010. It works perfectly well on all the machines it has been used on, both Windows XP and Windows 7. There is now a need for Mac based users to run the routine.

With some difficulty I’ve got the VBA code to work on a Mac using Office 2011. However, in this situation Mac runs produce all the required output files AND also produce the same number of files with the same names preceded by the symbols dot and underscore. In other words, while I have an expected set of output files “Reportnn” (where nn is an identifying integer) I also have an equal number of unwanted files named “._Reportnn”. I need to get rid of these, via code, before I present the output folder to the top-level user.

I’m very inexperienced with Macs.
1. Could someone please tell me what these unwanted files are, why they appear, and how I can get rid of them?
2. The reports produced on the Mac will need to be sent out to various users, some of whom are PC based. At present files "Reportnn" produced on a Mac claim, when I try to to open them on PCs, that they can't be opened by Excel even if they have a “.xls” suffix. The error message says “The file you are trying to open, ‘reportnn’ is in a different format than specified by the file extension.” This happens regardless of whether or not the file extension is present. How can I get round this?

TIA

John