topic Re: Export issue in QlikView

Export issue

Thu, 22 Aug 2013 19:04:24 GMT

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...

Re: Export issue

Anonymous — Thu, 22 Aug 2013 23:54:54 GMT

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

Re: Export issue

Sat, 24 Aug 2013 19:31:13 GMT

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 ....?

Re: Export issue

Anonymous — Mon, 26 Aug 2013 14:56:35 GMT

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

Re: Export issue

Mon, 26 Aug 2013 17:00:08 GMT

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?

Re: Export issue

Anonymous — Mon, 26 Aug 2013 17:11:59 GMT

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...