JasonEnsor
Programmer
Hi guys,
I am building a document generator of sorts that uses MS Word as the front end with a userform and Excel as the backend for some of the data. Due to the way the data is laid out I am able to query the data using ADO. What I am wondering is if it is possible to have images stored in cells in excel that I could then retrieve using ADO. If so any hints would be great.
At the moment I am considering storing the images on disk and in the ExcelDB doc having the location stored. Then when I retrieve the data load the selected image based on the filename. This however does open up potential issues with if the file is moved etc
Would appreciate any advice etc.
Regards
J.
I am building a document generator of sorts that uses MS Word as the front end with a userform and Excel as the backend for some of the data. Due to the way the data is laid out I am able to query the data using ADO. What I am wondering is if it is possible to have images stored in cells in excel that I could then retrieve using ADO. If so any hints would be great.
At the moment I am considering storing the images on disk and in the ExcelDB doc having the location stored. Then when I retrieve the data load the selected image based on the filename. This however does open up potential issues with if the file is moved etc
Would appreciate any advice etc.
Regards
J.