PDA

View Full Version : Runtime Error



tagliaboo
09-25-2019, 11:27 AM
I have an excel file with several macro that work fine on multiple computers. I have a new employee that just started and the macros do not work for him. He gets a runtime error -2147417848 (80010108). The specific macro is for creating a PDF if that matters. Not sure if it a setting in excel or version issue. Not the code since it works for everyone else.

Thanks

Paul_Hossler
09-25-2019, 11:37 AM
Hard to see from only a screen shot that cuts off part of the right side

Could be version differences, but probably not

Q: is the WB saved since Path might fail

Q: do all the pieces of the path exist

Q; is there a value in D11

Try running the sub and then copy the 'Filename' to the Immediate window:

Ctrl-G, then ?<paste it it.

tagliaboo
09-25-2019, 11:55 AM
Paul, The file is saved on the server. At the start of each project we copy the same file to a workfolder and start the project. All 10 of us use the same file and enter the information the same way. When the project is complete we create a proposal PDF with the macro shown. 9 of us have no issues , but one gets the error and then has to create the PDF manually. I'm stumped.