After VBA functions run. I get #N/A

[Diankathrine]

Hi, I'm trying to create a payroll sheet with button to create a password protected pdf and at the same time send it as an email. So I have the below code. My problem is I'm getting this runtime error '-2147024894(80070002)': cannot find this file. I know about this error and where it's coming from. What I don't understand is after I run the macros it creates #N/A and replaces the employee id with the name of employee. I don't know if I'm just sleepy that's why I couldn't find the error. Would really appreciate your help.

grrrr.PNG

Please Login or Register  to view this content.