https://community.qlik.com/t5/QlikView/Exporting-Graphs-to-Excel-via-Macro/m-p/1682568#M728064 <P>Hi, I have am issue where I am exporting graphs to excel using VB code and variables.</P><P>In the attached QVW file it loops through the variables and exports the sheets required, but it will only export one sheets worth of graphs as bitmaps.</P><P><BR />Has anyone seen anything similar to this before?</P> Sat, 16 Nov 2024 18:58:59 GMT lukegilligan 2024-11-16T18:58:59Z https://community.qlik.com/t5/QlikView/Exporting-Graphs-to-Excel-via-Macro/m-p/1682568#M728064 <P>Hi, I have am issue where I am exporting graphs to excel using VB code and variables.</P><P>In the attached QVW file it loops through the variables and exports the sheets required, but it will only export one sheets worth of graphs as bitmaps.</P><P><BR />Has anyone seen anything similar to this before?</P> Sat, 16 Nov 2024 18:58:59 GMT https://community.qlik.com/t5/QlikView/Exporting-Graphs-to-Excel-via-Macro/m-p/1682568#M728064 lukegilligan 2024-11-16T18:58:59Z https://community.qlik.com/t5/QlikView/Exporting-Graphs-to-Excel-via-Macro/m-p/1682729#M728065 <P>Managed to work this one out.</P><P>I am using&nbsp;obj.CopyBitmapToClipboard() to copy the graphs out to Excel which I have since found out will only work if the QV sheet I am copying from is active.</P><P>To ensure the sheet is active during the loop, I added the following to the start of the script:</P><P>ActiveDocument.ActivateSheet VarObj(i)</P> Sun, 08 Mar 2020 23:33:02 GMT https://community.qlik.com/t5/QlikView/Exporting-Graphs-to-Excel-via-Macro/m-p/1682729#M728065 lukegilligan 2020-03-08T23:33:02Z