Macro to retrieve files over network works on Excel 2007 but not with Excel 2010 or 2013

Hello,

First, please allow me to mention that I am not a programmer or an advanced user of Excel. I am a support person.

Someone who is no longer working at the company I work for created a macro to import images to an Excel sheet based of product ID in a database.
This macro works well on Excel 2007 but doesn't work on Excel 2010 or 2013. Could someone please tell me what needs to be done to make it work on Excel 2010 and 2013?

Thank you kindly,


Macro code:

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Please Login or Register  to view this content.

Are you sure the Excel version is the only thing different? You mean it worked on some particular computer with Excel 2007 and now with the same computer upgraded to Excel 2010 it no longer works? What are all the variables? It appears to be getting files over a network, which I haven't done in VBA, but the node descriptor looks odd to me, looks like a URL rather than a network node. Usually it would look like "\\IMAGE_SERVER" or "http://company.domain.com" but you have a sort of mash-up. On the computer where it doesn't work, if you just o to Windows can you navigate to the machine named in the VBA code?