error 2147352573 when inserting picture in Excel

[martti]

Hi all - HW&SW: IBM ThinkPad T40/ Win2000/ Excel 2000, LabView 7.0.
I try to insert a jpeg-picture into Ecxel sheet using Active X. Error 2147352573 and a message Member not found. in appl_1.vi - is the result.
Anyone have a clue what is wrong? I'd be very happy for your advice. See attached file.
Martti

[Khalid]

Hi,

The insert method didn't work for me either. It has something to do with the Excel::Pictures I guess.

I instead used Excel::Worksheet and the Shapes.AddPicture method; it works just fine.

See this post for details and example VI:
http://exchange.ni.com/servlet/ProcessRequest?RHIVEID=101&RPAGEID=135&HOID=5065000000080000009FBD0000&UCATEGORY_0=_51_%24_6_&UCATEGORY_S=0

Regards,

Khalid

[martti]

Thank you Khalid,
Your solution worked perfectly. Now I get the plot from Labview to Excel easily. Only drawback is that the image in Excel is not as sharp as it would be with insert-method.
Martti

[Joe_Guo]

Generally for plots/graphs, gif is much sharper than jpg. Too bad labview cannot save image to emf or wmf, this type of image can be resized without loosing quality (for plots) in Excel.

-Joe

[Andrew_E]

Hey Zeppelin,

I am thinking this is a known issue with LV 8.6 and report generation toolkit seen here at issue 123064. "Previously it was possible to access the references to MS Office documents by unbundling the refnum of the report that was passed through the report generation VIs. The Report Generation VIs were rewritten using LabVIEW classes, hence making this not possible" .  The work around can be found here.

Although you don't get the broken run error, I am thinking this could still be the problem with your vi, since it has solved other very very similiar problems.

Regards,