Multiple Pictures In A Price List

I've never imported pictures before, but this should get you started. You might need to write some other coding to resize the pictures.

Here's the link where I found the InsertPictures function:
http://www.exceltip.com/st/Insert_pi...Excel/486.html

Please Login or Register  to view this content.

Hi
the macro in attached file inserts and resizes pictures. keep pics in the same folder as this file and run the macro
ravi

Hello Craig_Adobe,

Welcome to the Forum!

Here is another version. The macro starts at cell "A2" and finds the last row automatically.Since you didn't mention what size you want the pictures, the pictures are inserted full sized. You will need to determine the pictures dimensions for your spreadsheet at some point or the pictures will be a big jumble. This also means the row height should be set to the max height allowed for a picture.

You can change the starting cell, the picture column, and the picture extension in the macro. They are marked in red.

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Sincerely,
Leith Ross

Thanks for your help everyone...your great help has now raised extra questions - is it possible to get the macro to resize the photo (height but not width) to suit the cell size so that it is framed nicely by the border?? The width of the photo should maintain the original proportions of the photo so that everything looks sweet ??? I'm probably asking too much.

I've attached a copy of page one of my project so that you get a better feel for what we are trying to achieve.

Once again thanks for your help.

Hello Craig_Adobe,

Could you post an Excel 2003 version as well?

Sincerely,
Leith Ross

This worked for me a few years ago
http://www.excelforum.com/excel-misc...n-sorting.html

Regards

Dav

Hi
The macro in attached file picks pictures named in col C (15 to 23 or last row) and pastes them in col H.
Ravi

Hi attached is the older version...

Regards,
Craig

Hi Ravishankar, Thanks for your file that was great. Is it possible to get the picture to fit the cell size rather than re-size all of the row heights as a part of the macro? This would allow us to have some cells larger than others to highlight some products [new ones those on special etc.]. Also [sorry to sound so needy] is it possible for the macro to insert one consistent photo (named Abodelogo.jpg) when a photo of the code doesn't exist?

Thanks for your help

Regards,
Craig

Hi
Give this a try
Ravi

Thanks Ravi - you are a LEGEND !!