topic How to copy a chart by Macro? in QlikView https://community.qlik.com/t5/QlikView/How-to-copy-a-chart-by-Macro/m-p/174018#M42995 <HTML><HEAD></HEAD><BODY><P>Hi, John.</P><P>Try to use function WriteXmlPropertiesFile and CreateObjectFromXmlPropertiesFile.</P><P>Examples from API guide:</P><P>ActiveDocument.GetSheetObject( "CH01" ).WriteXmlPropertiesFile "C:\MychartProp.xml"<BR />ActiveDocument.ActiveSheet.CreateObjectFromXmlPropertiesFile "C:\MychartProp.xml"</P><P><BR /></P></BODY></HTML> Wed, 10 Mar 2010 10:07:29 GMT sparur 2010-03-10T10:07:29Z How to copy a chart by Macro? https://community.qlik.com/t5/QlikView/How-to-copy-a-chart-by-Macro/m-p/174017#M42994 <HTML><HEAD></HEAD><BODY><P>If there is a chart(CH01) in active sheet, I want to copy this chart to another sheet.</P><P></P></BODY></HTML> Wed, 10 Mar 2010 09:43:40 GMT https://community.qlik.com/t5/QlikView/How-to-copy-a-chart-by-Macro/m-p/174017#M42994 Anonymous 2010-03-10T09:43:40Z How to copy a chart by Macro? https://community.qlik.com/t5/QlikView/How-to-copy-a-chart-by-Macro/m-p/174018#M42995 <HTML><HEAD></HEAD><BODY><P>Hi, John.</P><P>Try to use function WriteXmlPropertiesFile and CreateObjectFromXmlPropertiesFile.</P><P>Examples from API guide:</P><P>ActiveDocument.GetSheetObject( "CH01" ).WriteXmlPropertiesFile "C:\MychartProp.xml"<BR />ActiveDocument.ActiveSheet.CreateObjectFromXmlPropertiesFile "C:\MychartProp.xml"</P><P><BR /></P></BODY></HTML> Wed, 10 Mar 2010 10:07:29 GMT https://community.qlik.com/t5/QlikView/How-to-copy-a-chart-by-Macro/m-p/174018#M42995 sparur 2010-03-10T10:07:29Z How to copy a chart by Macro? https://community.qlik.com/t5/QlikView/How-to-copy-a-chart-by-Macro/m-p/174019#M42996 <HTML><HEAD></HEAD><BODY><P>Hi sparur.</P><P>Thank you very much. It's work fine.</P><P>I would like to know how can I do if I want to copy it from Sheet01 to Sheet02 ?</P><P></P><P></P></BODY></HTML> Wed, 10 Mar 2010 10:36:21 GMT https://community.qlik.com/t5/QlikView/How-to-copy-a-chart-by-Macro/m-p/174019#M42996 Anonymous 2010-03-10T10:36:21Z How to copy a chart by Macro? https://community.qlik.com/t5/QlikView/How-to-copy-a-chart-by-Macro/m-p/174020#M42997 <HTML><HEAD></HEAD><BODY><P>try to use function ActivateSheetByID:</P><P>ActiveDocument.ActivateSheetByID "SH02"</P><P>and then create new object from xml<BR /></P></BODY></HTML> Wed, 10 Mar 2010 11:13:43 GMT https://community.qlik.com/t5/QlikView/How-to-copy-a-chart-by-Macro/m-p/174020#M42997 sparur 2010-03-10T11:13:43Z How to copy a chart by Macro? https://community.qlik.com/t5/QlikView/How-to-copy-a-chart-by-Macro/m-p/174021#M42998 <HTML><HEAD></HEAD><BODY><P>OK,I will try it.</P><P>Thank you!</P></BODY></HTML> Thu, 11 Mar 2010 03:30:10 GMT https://community.qlik.com/t5/QlikView/How-to-copy-a-chart-by-Macro/m-p/174021#M42998 Anonymous 2010-03-11T03:30:10Z