I discover a few things:
1. On my PC the file path is:
On her MAC it’s:
“Macintosh HD:Volumes:Customer:MAC Job:Data.csv”
2. There are some VBA Object methods not available like .HasText (could it be the old office version?)
3. Mac does like the ChrW characters and says they are unreliable.
4. Access isn’t compatible with the Mac and even if she had FileMaker I didn’t.