PDF attaches with one file name, but not another

I’m stuck. I’ve got this VBA script that will save worksheet to pdf, then attach it to a newly created draft email via Mac Script. Everything works as intended IF the pdf file named in the 'pdfFileName = "Carl.pdf" line. If I change the file name to 'pdfFileName = "Dave.pdf" (or any other name) I get an invalid procedure error. In both cases, the pdf is correctly saved in the correct path, just “carl” will attach the file & “dave” will not. So, I know the files both exist where they should, so they should both work. I’ve tried a ton of variations and have been trying suggestion from AI. Any insight would be appreciated. I’ve attached a truncated version if the VBA & Apple Script. Thanks in advance

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.
For new members: you will not be able to post a full URL, so remove the https://www. section and add one or two breaks to the rest of the address. A Moderator or Admin will then fix the link for you.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)

While you have told us where, you have not posted the links as requested. Did you read the link provided to understand why we ask for this.

I fixed your code to remove the extra line break after every line of code.

If you are using Outlook, why are you using AppleScript to manage email creation instead of using what is built into VBA for the purpose? Troubleshooting your approach will require some rather esoteric knowledge.

I looked into this and you are correct. MacOS sandboxes its applications so this sort of cross-application communication is blocked. That's too bad since it's such a powerful feature of VBA.

Is it the same file other than the name?

You could try saving Carl, then rename it to Dave, and see if it works. You'd need to hardcode the path or update the variable.

@Soundman

First, let me make it clear that I have no issue with cross posting, so long as it is done correctly. If you feel that you get more experts pointed to your posts, then fine. What we are asking for, however, is the courtesy of knowing about it. Why? Well it's kind of simple really. If you post on several boards, you have several groups of people working on the same issue, without necessarily knowing what the others are doing.

Ask yourself this: How would you feel if you worked on an answer for an hour, only to find out that fifteen minutes after you started, someone already had a solution they accepted? I'd be willing to bet you'd be a little upset that you'd wasted your time. Putting it simply. It is the courteous thing to do.