Hello everybody,
I am currently running an excel file in which I have created an order form that people can fill out with their information and the products that they would like to order. I am using a VBA code (please let me know in the comments if you want me to attach the entire code) attached to a macro I named "Submit Order" which converts the excel file to a PDF file and sends it by email to me. Following this, Excel (Microsoft Visual Basic) should provide me with a message saying "Your order has been submitted by email. Thank you.".
However, I recently sent this file to a friend, who renamed the file name from "Order form" to "Order form for xxx goods - department number". After this, he uploaded the file to our shared file database in Microsoft teams and when I downloaded it (please note that he has made no changes whatsoever to the file except for changing its name) and tried to run the macro it provided me with the following error:
Now, for some strange reason, the excel file actually still sends out the email despite the visual basic error.
When I try to debug the file I get the following information:
With a closer look my note "Kill strPath" links me to our sharepoint location for some reason:
My own file looks like this with no error at all and no link at the "Kill strPath":
Finally, when the error email that I sent out when I clicked on the macro in my friends file also renamed his file to "Order%20Form" for some reason and not what he had changed the name to.
Does anybody have any idea how I can fix this? Especially so the right message is shown after clicking on the macro in my excel file.
I realize that this is quote cloudy, so please if you have any questions, want further information or anything similar, do not hesitate to ask me!
Whoever has read all of this, thank you so extremely much for your time! I would be thrilled to get some assistance in this matter.
Best regards,
David
I am currently running an excel file in which I have created an order form that people can fill out with their information and the products that they would like to order. I am using a VBA code (please let me know in the comments if you want me to attach the entire code) attached to a macro I named "Submit Order" which converts the excel file to a PDF file and sends it by email to me. Following this, Excel (Microsoft Visual Basic) should provide me with a message saying "Your order has been submitted by email. Thank you.".
However, I recently sent this file to a friend, who renamed the file name from "Order form" to "Order form for xxx goods - department number". After this, he uploaded the file to our shared file database in Microsoft teams and when I downloaded it (please note that he has made no changes whatsoever to the file except for changing its name) and tried to run the macro it provided me with the following error:
Now, for some strange reason, the excel file actually still sends out the email despite the visual basic error.
When I try to debug the file I get the following information:
With a closer look my note "Kill strPath" links me to our sharepoint location for some reason:
My own file looks like this with no error at all and no link at the "Kill strPath":
Finally, when the error email that I sent out when I clicked on the macro in my friends file also renamed his file to "Order%20Form" for some reason and not what he had changed the name to.
Does anybody have any idea how I can fix this? Especially so the right message is shown after clicking on the macro in my excel file.
I realize that this is quote cloudy, so please if you have any questions, want further information or anything similar, do not hesitate to ask me!
Whoever has read all of this, thank you so extremely much for your time! I would be thrilled to get some assistance in this matter.
Best regards,
David
