Hello,

I am having an issue with a Macro which opens all excel files in a folder.

I work in a Windows Domain Environment which has Mac users, when Mac users open am excel file on a server. It sometimes creates a copy of the file beginning with ~$ or ._

If these files exist, the macro will error on the file.

I can delete the files to make it work, but the n the process will not be automated.

Thank you in advance. I've attached a screenshot of the files within the directory.
Mac Files.jpg