ActiveSheet will not export to PDF - runtime error 5

I have a macro that takes a certain tab, changes the variables, copies the sheet and the prints the individual sheets to PDF. I have used this in more than one workbook successfully, however, when I tried to update another file this morning, I receive the runtime 5 error when it gets to the red portion. I have tested the other workbooks with this code and it works perfectly.

I have resaved the file as macro enabled workbook and checked the code is identical in all workbooks. Does anyone have any suggestions on file settings to tweak that may be causing the issue? I know the code itself should not be the problem as it works perfectly in other workbook files.

Please Login or Register  to view this content.

Removed because when I edited it, for some reason it appeared in post # 3

I haven't seen the desktop = call out before so I could be wrong about this, but usually in "mypath" there has to be a drive letter included

Please Login or Register  to view this content.

or maybe

Please Login or Register  to view this content.

My mistake, I didn't read your post fully, sorry about that.
Should

Please Login or Register  to view this content.

be

Please Login or Register  to view this content.

I tried to use your code in a blank workbook to see if I could recreate the error, but, not all of the code is there so it's being very difficult.
Edit* It looks as if all your Physician words are missing quotes.

Yea, I will post the full code below, so others can try. Physician is actually a defined variable, as there are many throughout the schedules and I am printing an individual schedule for each of the physicians in the file.

The code runs until it hits the section which wants to export it as a PDF.

Please Login or Register  to view this content.

Hmmmm...Interstingly enough, as long as I had something in range A9:A24 of the Modeling Detail sheet, it ran perfectly fine.

Check to be sure that the sheet names that it is trying to create do not already exist. When I ran the code a second time with the same values/text in the A9:A24 range, it would error out for me where you are getting the error because it cannot create the same sheet name more than once. Once I deleted those sheet names, or changed the values/text in A9:A29, it worked fine.

Glad you got it worked out!