Let me start by saying i'm a Mac noob to say the least. I have an excel sheet that works great for my PC users, but i need to modify it for my Mac users as well. For the most part, i have changed everything i need to, however i'm totally stuck on the save to function for Mac
I need my users to have the ability to save to a specific network location even if they don't have a mapping to the location. i was able to do this very easily for my PC users with the below line:
ThisWorkbook.SaveAs Filename:="\\atnyfs01\ispub$\Help_Desk\New Hire Backup\" & Sheets("New Hire Form").Range("C14").Value & " " & Format(Date, "mmddyy") & Format(Time, "hhmm") & ".xls"