Macro to insert photo automatically in EXCEL 2007

Hi,

i have been using the bellow code in Excel 2003 to insert photos from a folder automatically.

Recently i've passed to EXCEL 2007, and it's not working anymore.

The idea is to insert photos in column A based on the product name present in column B, and starting from the active.cell. The photo is inserted in row left to the product number, and have a specified width.
Then it goes down inserting the photos automatically in a loop for all the products in B.

Anybody knows how to update it for Excel 2007?

Thanks!!!
Nicolas


Here the code:

Please Login or Register  to view this content.

Something like this,

Please Login or Register  to view this content.