Hi all,
i am writing a macro to generate excel file
in my qvw i hv several buttons to trigger hide/show chart or select dimension of chart
e.g.
there are 2 charts and 4 buttons
button 1 and 2 will show chart 1 with different dimension selection, button 3 and 4 will show chart 2 with different dimension selection
now i will simulate the 4 button click in my macro to generate the 4 charts and put them in 4 separate sheets in one single excel file
i found that if i use this in my macro:
For ...
...
' press a button before get sheet object
Set x = ActiveDocument.GetSheetObject(varChartObjectID)
varColCount = x.GetColumnCount
...
Call x.CopyTableToClipboard(true)
...
' use this varColCount to do formatting to the last column
...
next
the varColCount is sometimes wrong, which is always 1 column less if happens
at the same time, if such issue occurs, it does not appear in all sheets
but the chart is always complete (with all columns shown)
Please try commenting and thanks to all
