export picture

Sun, 25 Aug 2013 18:43:55 GMT

i am using macro to export chart image into excel

and it is working fine when i used it from Qlikview destop.

but when i use the same macro on access point using IE Plug in

it is showing Qlikview Ocx message

macro not purged

with error message 'unable to get insert picture class property'

below is the syntex how i am using insert image to excel...

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

where i am passing imagename ,strpath,srtfiledate:

strFileDate= strYear & "-" & strMonth & "-" & strDay & "-" & strHour & "-" & strMinute & "-" & strSecond&".bmp"

strPath = wshShell.SpecialFolders("MyDocuments")

Please let me know how it will work in access point as there is no logical error as code is working in Qlikview Destop.

on server allow macro is click even unsafe macro also click also allow in document level.

For Export i am using below expression:

chart.ExportBitmapToFile strPath&"\"&imgname&"_"&strFileDate

Re: export picture

whiteline — Sun, 25 Aug 2013 19:35:22 GMT

Hi.

Do you have the same (as yours) version of Excel installed on the mashine where QV Server is hosted?

Mon, 26 Aug 2013 08:15:33 GMT

Macro run on client machine so i do not think it will create any issue .

i have excel 2007 on my machine.pls update me