Mac Excel cannot find file path - code error

[MermaidNiki]

Hi,
Can someone please peek at this code and let me know why I get a "path not found" 76 error. This code works fine on a PC. It's got to be some weird Mac thing. We made sure to use Application.PathSeparator in place of / , but the FileExist function keeps popping up a bug.

Please Login or Register  to view this content.

Thank you

[rorya]

What are the actual values of PathName and FileNameF and FileNameC?

[MermaidNiki]

What are the actual values of PathName and FileNameF and FileNameC?

Thank you!
They are:
Path /Users/mermaidniki/Desktop/AllTheOtherUseThis/PhDDataForAnalysis/ExcelFiles/FertileFemale
FileNameF /Users/mermaidniki/Desktop/AllTheOtherUseThis/PhDDataForAnalysis/ExcelFiles/FertileFemale/NBdata.csv
FileNameC /Users/mermaidniki/Desktop/AllTheOtherUseThis/PhDDataForAnalysis/ExcelFiles/FertileFemale/FertileFemaleCount.xls

BUT FileNameF will change - I have about 30 files that this needs to run on.

[MermaidNiki]

I did try replacing this code

Please Login or Register  to view this content.

With this code

Please Login or Register  to view this content.

And anything that called the function as well. Then it pushed through the file not found, but wound up with new errors. I think this may be a lost cause on a Mac unless I can find an expert. =(