Excel VBA Code to Open Images on other computers

[acool]

Hi Everyone,

I am currently trying to create an excel VBA macro that populates the company logo after running it each time. The png image is stored in a shared folder and is accessible to everyone. I have no issues populating the image on my own laptop, however it becomes an issue when others try to run the macro on their own computers. To make code functional for everyone, I tried removing my personal user name in hopes that this would do the trick, however, I'm still receiving an error. Below is photo of the the code that properly runs (top), and the code that I changed it to which I am having issues with. if anyone knows of a fix and is able to share, that would be greatly appreciated. Thank You!

 

[Micron]

What comes after the \\ needs to be the server name. Since you also use "Company" where you used C: I'm guessing that is not the server name. What you might want to lookup is UNC path syntax. Not sure if that will solve your issue because saying you're having issues doesn't give anyone much to go on.