This code is unreliable, Anyone know what I got Wrong?

I created A simple spread sheet that requires certain information before allowing submit. Upon submit it Saves a PDF of the spreadsheet, attaches it to an email and sends it to our Helpdesk email, then kills the PDF. Well it was working fine on my PC, I sent it to another collegue to test it out, and it ran everything up to adding the file to the email and failed because it couldn't find the file (though it was saved on the desktop). It works sometimes I use it and it fails sometimes. Anyone have thoughts on what to fix? VBA is not at all my strong point. I have very limited knowledge of it, and most of this code was found in these forums. I need this to work seamlessly, but Not sure how to get there. Thanks for the Help! Please forgive me if I put the Code in the wrong place. (Email address it sends to has been removed FYI)

Please Login or Register  to view this content.

Your attachment is corrupt.

How is it supposed to end up on the user's desktop, unless that path is in A1?

If at all possible, don't use Desktop or it's subfolders.

In many companies, Desktop can be provisioned through LogonScript or other means (via ActiveDirectoryObject), and may not be same as what is normally considered as Desktop (C:\Users\Username\Desktop).

I'd recommend using FSO or MkDir to choose/create folder to save the PDF.

Please Login or Register  to view this content.

Does the file appear on the desktop?

What's the filename?

Unrelated to the problem, but it should have a dot in it:

Please Login or Register  to view this content.

Put a breakpoint into the code and from the immediate window, after the filename is initialized, enter

Please Login or Register  to view this content.

What do you see?