Re: Macro to save selection as .csv Run-time error '1004'
Quote from luck_excel;771773
Thanks for your suggestion, I tried it already and tried again I'm running on Mac Office 2016 if that makes any difference. Like you I thought the path would be using the \ but it seems that regardless / or \ I get the same error message.
ahh.... with Mac Office... the filepath structure will be different because it is UNIX. From the limited experience I have with MAC.. i dont believe the / or \ is needed at all... so just remove it. Failing that, have a read of this guide, maybe it'll provide some clues!