Hey guys,

I'm new to VBA/Macros and I have a fairly complicated problem that requires a robust solution.

Essentially I have a folder of images on a file server. All these images are the same size and have the same filename nomenclature. I need an excel file to take names from Column A and automatically insert corresponding images, resized to fit into Column B.

For example:
If cell A2 holds the value "September21" I need the image titled "September21.jpg" from a specified folder to be inserted and resized (to 2" by 2") into cell B2.

Right now I'm running Excel 2011 on MAC, but the macros needs to work for both Windows and MAC Excel 2011. I've tried a plethora of solutions but nothing seems to work with MAC (let alone both MAC and PC).

Please, please any help or references would be very appreciated! I've been stuck on this for days.

Thanks!