I have code that takes an Excel worksheet, converts it to a pdf, creates an email with the pdf attached, then displays the email so the user can add comments and send it.
It was working fine on my computer last week, but now I get this error:
Run-time error '-2147024894 (80070002)':
Cannot find this file. Verify the path and file name are correct.
Anyone have any idea what's going on or how to fix this?
Here is my code and I indicated the line that's highlighted when I Debug:
![]()
Please Login or Register to view this content.
My work computer: Windows 10 Enterprise / Office 2010
- Code worked last week, but now won't work
Co-worker's computer: Windows 7 Pro / Office 2010
- Code doesn't work
My test work computer: Windows 7 Pro / Office 2010 - has not been used for months, so hasn't had any recent updates
- Code doesn't work
My personal computer: Windows 10 Pro / Office 2016
- Code works fine
Bookmarks