Excel for Mac: Need help converting Windows split to txt macro

[ncalsurfer]

Hi All - just to preface everything, I'm a total vb hack - as in cut/copy/paste and try to make things work. The script below worked on my windows machine, but won't work on my Mac. I get a path/access error. Could someone please help me?

Please Login or Register  to view this content.

[Cutter]

@ ncalsurfer

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

[JosephP]

you need : instead of / in your folder path

[ncalsurfer]

Thank you JP, but I don't think that's the issue as I have tried all maner of slashes and : in my folder path and none of them work.

If I choose to debug the error it spits me out on this line:
Open MYFILE & "C2NXT_STD.txt" For Output As #FileNum

I know this is referencing the folder path though, so perhaps I'm not commenting properly for the space in the path? Or could there actually be a permissions issue trying to reach that folder?