I am trying to edit this code so that it will work on a Mac. Right now I can't figure out how to get the Dir() or .SaveAs functions to work. I think I am supposed to use MacID(), but I don't understand the different resource types or how to specify to only look for folders instead of any file type. My code works on Windows, but when I email the excel file to someone using a Mac, they get a run time error 68.


Please Login or Register  to view this content.