Excel VBA code can't find file path on MAC

I do not have a Mac but my understanding is that the path delimiter on a Mac is : not \ or / as in Windows. Try making that change, if you will use this exclusively on a Mac. I don't know how it ever worked in the past.

If you need to use it on both Windows and Mac then use Application.PathSeparator wherever you need to use a delimiter.

I just noticed you listed Windows 10. Are you running a virtual Windows 10 OS on a Mac?

Would also be interesting to know what is returned when you run the below:

Please Login or Register  to view this content.

I though I had replied previously, but I will try again.

I tried simplifying things and created a new module in the same workbook with the code as follows:
Sub OpenPDF()
ThisWorkbook.FollowHyperlink ActiveWorkbook.Path & "SCUF.pdf"
'Note: I renamed the file so that there weren't any spaces'
End Sub

The ActiveWorkbook Path is /Users/jeffhanner/desktop/create SCUF/

I can substitute the path and file name for a URL and it opens the URL in the browser, however I tried to open many different files and got the same error - that it can't find the file. Since I'm only working with Excel for Mac and not Access right now, Windows 10 is suspended in Parallels. One thing that is interesting is that it can find and open the file when MS Access is used and it can populate the fields in the PDF, but it can't save the document as in the past. I'm not concerned right now about making it work from Access, so that is why I'm trying it with just Excel for Mac. I don't know what else to do. Thanks for you help so far.

I did find out that the Hyperlink function from within a cell works fine and opens the pdf file.

I've discovered several important things to clarify my problem.

1. Originally this was a problem with MS Access calling Excel Macros which were to open a PDF form and then populate it with Excel Data which it didn't

2. I removed MS Access from the problem and worked with Excel Macros alone. I eventually got Thisworkbook.Hyperlink to find the file (on the MAC). However, when the PDF file opened, none of the keystrokes sent with Application.Sendkeys worked.

3. I watched a video from Excel Freelancers and the code I had was correct.

4. I had access to a PC so I moved the Excel file with its VBA code and the PDF file to C:\SCUF. Not only did the PDF file open, the file was filled and saved correctly.

So that leads me to believe that either the code doesn't work correctly with the MacBook Pro M1 or a setting has to be changed. It would be great if the MS Access code could call the Excel Macros on the Mac, but I've finished what I needed to do on the PC.

If you come up with anything, please let me know. Thanks for your help.