ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Inserting image file through ADO (https://www.excelbanter.com/excel-programming/426792-inserting-image-file-through-ado.html)

news.microsoft.com[_16_]

Inserting image file through ADO
 
Hello,

I am generating excel sheet through ADO (ISAM) but how to insert some image?

Thank you

Regards

Raj



Jacob Skaria

Inserting image file through ADO
 
Activeworkbook.ActiveSheet.Pictures.Insert("c:\1.j pg")

If this post helps click Yes
---------------
Jacob Skaria


"news.microsoft.com" wrote:

Hello,

I am generating excel sheet through ADO (ISAM) but how to insert some image?

Thank you

Regards

Raj




news.microsoft.com[_16_]

Inserting image file through ADO
 
Is this code possible from ADO?!
"Jacob Skaria" wrote in message
...
Activeworkbook.ActiveSheet.Pictures.Insert("c:\1.j pg")

If this post helps click Yes
---------------
Jacob Skaria


"news.microsoft.com" wrote:

Hello,

I am generating excel sheet through ADO (ISAM) but how to insert some
image?

Thank you

Regards

Raj






Jacob Skaria

Inserting image file through ADO
 
This works only if you have an Excel Object...When using ADO.net with Excel
ie; as a database there are a number of limitations like..you cannot insert
formulas, cannot delete a record...OR in short you cannot use the workbook
functionalities..
What happens when you execute the query and try to insert a picture data
field.

If this post helps click Yes
---------------
Jacob Skaria


"news.microsoft.com" wrote:

Is this code possible from ADO?!
"Jacob Skaria" wrote in message
...
Activeworkbook.ActiveSheet.Pictures.Insert("c:\1.j pg")

If this post helps click Yes
---------------
Jacob Skaria


"news.microsoft.com" wrote:

Hello,

I am generating excel sheet through ADO (ISAM) but how to insert some
image?

Thank you

Regards

Raj








All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com