Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Has anyone seen anything similar to this before?
Managed to work this one out.
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:
ActiveDocument.ActivateSheet VarObj(i)
Managed to work this one out.
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:
ActiveDocument.ActivateSheet VarObj(i)