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
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.
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
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.
Reply With Quote
