Export issue

[#1]

i have created a macro to export chart image into excel in VB script.

it is working when i am using it by opening application in qlikview.

but when i try it on access point using IE plug  In , it is showing error ''unable to get insert picture class''

there is no issue in code as it is working right in qlikview .

Please let me know any one have same issue  and how to resolve it.

I am using Qv 11SR2.

Thanks...

[Anonymous]

In most cases the macros that work in Desktop works also in IE Plugin.  Make sure that QVS settings allow "unsafe macro", and that the end user allows all macros as well.

Regards,
Michael

[#3]

already allow unsafe macro as well as all macro..

even other macros are working fine

i am getting error for insert image'unable to insert picture class property'

even working fine from qlikview desktop

but not from access point

Set p = objExcel.ActiveSheet.Pictures.Insert(strPath&"\"&imgname&"_"&strFileDate)

i am using above logic and passing path, image name,strfile field.

any other suggestion ....?

[Anonymous]

It doesn't look as a QlikView issue.  Sometning in the environment, that I can't tell.  Different Excel version on Server?

Try to open a support case with QlikTech, or maybe with Microsoft.

Regards,
Michael

[#5]

might be invoirnment issue but Qlikview have somthing to fix it.

even i tried to record macro in excel 2007 but not recording any thing for insert picture for other boject its recoding.

in excel 2010 i can record the macro. all i want to know how can i use Insert picture in excel 2007

is there any other key word or it is a bug?

[Anonymous]

I just googled it a little.  Appears that Excel 2007 behaves differently than 2010 or 2003.  I'm not saying if it is a bug, but it may be...