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.
Bookmarks