Home » Forums » Open Source Learning Center » Question and Answer

Getting icon-like graphics into excel.

Submitted by drew_blank on 2 December, 2011 - 18:15

I am looking to type part numbers into a sheet and then have it look into my drawing folder, and create a smaller version of the drawing in the sheet beside the part number.

Most of the drawings are in PDF format.

Basically like a catalog but without a description.

I have weekly reports of products required to ship, that I'm trying to make a list with a small drawing beside for pickers to find and package.

Is there a way to do this?

‹ Help! Lotus Mail from VBA (How to choose from which user id to send mail?) Need additional macro code ›
»
Vishesh's picture

This is definitely possible.

Submitted by Vishesh on 3 December, 2011 - 17:56.

This is definitely possible. However, for this the part number that you type should match with the file name of the image. The folder path of the images should also be known to look in.

This is possible via macros.

»

Matching via macros

Submitted by Anonymous on 5 December, 2011 - 21:52.

Okay, I thought that it might be possible, and we do have the drawings matching the part numbers.
I already have an access db that finds all the drawings in any of the folders under the root /drawings folder.

I was just trying to make it possible to view small previews in the cells of excel without having to make a bunch of jpeg files in the same folder as the original pdf's and solid models.

So, then my macros could make use of my batch files that already look up the drawings, but how do you made the preview in the cells of excel?
That is the part I'm stuck on...

Is it like snap-shot in access and just print to screen verses to printer or file?

Thanks,
Drew

»
Vishesh's picture

So you already have the

Submitted by Vishesh on 6 December, 2011 - 05:19.

So you already have the mapping (part number to image file) in Access DB. This can easily be used from Excel.

Regarding showing the preview in a cell you can import the file in Excel and resize it. The same process can be repeated for any part number that the user enters - simply delete the previous image and load a new one.

Manual process:
In Excel menu
Insert -> Object -> Create from file
Choose file and click OK.
Resize the imported image.

Above process can be automated through macros.

»