Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi.
Do you have the same (as yours) version of Excel installed on the mashine where QV Server is hosted?
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