rocknRobin
Programmer
Hi everyone,
how do you copy an image from an access table and insert it into an excel cell?
I made a form that allows the user to populate a new excel spreadsheet with the click of a button - works fine, I just need to ad an image and I'm done but....
while I can drag and drop a bitmap into an OLE field of the DB, which saves it forever more, how do I extract it and pop it in as an image in Excel using VBA? (or some other method?)
This isn't an image DB, just one image that's supposed to be distributed within the DB itself, I'm storing it in the DB so that the users won't modify or replace it with some hilarious substitute when the DB is sent to folks out on site.
If anyone needs more info please let me know - all the best,
Rob.
(oh and I can't depend on the image path remaining consistent - someone will eventually 'accidentally' delete it..soo it's got to be stored in a table)
how do you copy an image from an access table and insert it into an excel cell?
I made a form that allows the user to populate a new excel spreadsheet with the click of a button - works fine, I just need to ad an image and I'm done but....
while I can drag and drop a bitmap into an OLE field of the DB, which saves it forever more, how do I extract it and pop it in as an image in Excel using VBA? (or some other method?)
This isn't an image DB, just one image that's supposed to be distributed within the DB itself, I'm storing it in the DB so that the users won't modify or replace it with some hilarious substitute when the DB is sent to folks out on site.
If anyone needs more info please let me know - all the best,
Rob.
(oh and I can't depend on the image path remaining consistent - someone will eventually 'accidentally' delete it..soo it's got to be stored in a table)