how to insert a picture into excel ?

Find and share HowTos to various installations / configurations!
3 posts • Page 1 of 1
feixiang
Posts:6
Joined: Thu Jan 21, 2021 5:37 am

how to insert a picture into excel ?

Post by feixiang »

Dear all,
Does anybody known how to insert a existing picture file to a excel use control script?
I try use Shapes.AddPicture method, but the warning message is "Function not defined"?
BTW:I can do add value and chart by refer wincc oa online help.
Best Regards,
Fei Xiang

kilianvp
Posts:443
Joined: Fri Jan 16, 2015 10:29 am

Re: how to insert a picture into excel ?

Post by kilianvp »

you can't insert a existing picture file to a excel use control script. You need a external tool or a ctrl extension

feixiang
Posts:6
Joined: Thu Jan 21, 2021 5:37 am

Re: how to insert a picture into excel ?

Post by feixiang »

Thank you very much!
Got it.
I use control script transfer filename to excel, and user excel Macros Shapes.AddPicture function insert picture.
It's ok now.

3 posts • Page 1 of 1