The “Download Office 2007 B2TR Control ID List” file apparently contains the control names that need to be passed into the GetImageMso function (in place of strName) – it looks like the download includes the control names for Access, Excel, Outlook, Power Point, and Word.

Good luck.

]]>By: Paul D Pruitthttps://hoopercharles.wordpress.com/2009/12/28/extract-1834-images-from-excel-2007-and-transfer-to-a-database-table/#comment-235
Sat, 23 Jan 2010 17:51:20 +0000http://hoopercharles.wordpress.com/?p=536#comment-235I was able to insert the images in my proper rows using a macro I found, although it was much less elegant as I used one line of code for each image.

My new problem is how to rewrite your code for extracting Word and PowerPoint QAT commands. If you have any suggestions, let me know.

Thanks so much for your feedback. I actually did something better I downloaded Oracle Express and once I got the two references Microsoft ActiveX Data Objects and Microsoft ActiveX Data Objects RecordSet Library (I think I needed both) and then changed the code to enter my database name (automatically named “XE” for Express) , my username (“system” as mentioned in setup) and password as set in during install, it worked smoothly. I earlier had created the table in Oracle once I figured out I need to connect to the database first in the SQL CMD interface.

So now I have the Excel spreadsheet as described. I also have the directory filled with images with the right names, which is actually more valuable. So now my problem is getting the images in the table in the correct rows that also have the QAT the respective command name. This though is my problem, you’ve done your part! Thanks so much! I spent two days looking for a solution to this problem.

Hi, I admire your posts even though I don’t have Oracle. I’m in need of the images from the Quick Access Toolbar-QAT commands for Word, Excel and PowerPoint. Can you make these available in Excel spreadsheet form for download?