Hi, I have am issue where I am exporting graphs to excel using VB code and variables.
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.
I am using 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.
To ensure the sheet is active during the loop, I added the following to the start of the script:
I am using 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.
To ensure the sheet is active during the loop, I added the following to the start of the script:
