Custom BOM to include thumbnail

Custom BOM to include thumbnail

bradley_rinschen
Participant Participant
156 Views
0 Replies
Message 1 of 1

Custom BOM to include thumbnail

bradley_rinschen
Participant
Participant

Apologies if this has been posted but I can't find any entries addressing this specific aspect of this. 

 

I see that within an Assembly I can export the BOM to Excel and it contains the thumbnails in a column. I have my own VBA macro running to create a BOM with several dozen other properties and I want to include the thumbnail on it. So far every attempt I’ve made to access it has not worked. I’ve found postings online alluding to it being more difficult on a 64-bit machine than 32 and various means of doing it, but so far none of them have worked. It appears to simply be stored as an iproperty but accessing it like any other iproperty errors out.

 

I’ve found means of saving the thumbnail for every file as a bmp to a temp folder and then accessing those to insert into Excel, but given how fast the native BOM is created from an assembly there’s zero chance this is how Inventor is natively getting them to populate. And doing that would greatly slow down the overall process that I have running.

 

How do I replicate the same method that Inventor natively uses? It would legitimately be faster to make it output the overall BOM as an excel file and then copy the cells from that file into my own than to save a bitmap of every file individually to then later insert. I briefly attempted to use the clipboard to paste instead of saving, but if the user hits ctrl+C on an email while it's running, everything crashes out. 

0 Likes
157 Views
0 Replies
Replies (0)