VBScript Line Chart Export to Excel

[haymarketpaul]

QV11 SR4

I use VBScript to construct an Excel Document which works fine.

I would also like to export/paste a Line Chart to an Excel Sheet via VBScript.

When i attempt to export my line chart with the following...

ActiveDocument.GetSheetObject("CH_Contacts").CopyTableToClipboard True

XLSheet2.Paste XLSheet2.Cells(num_rows+4,num_cols-10)

...Instead of pasting the chart it just pastes the values the chart is based on as a straight table.

Is there a way to paste/export the actual line chart as a line chart ?

[tamilarasu]

Paul,

I couldn't see any any line chart in your attachment. Could you please post correct qvw file and sample output file (Chart position in excel sheet).?

[haymarketpaul]

The line chart is on the Running Counts tab of the qvw i attached.

I've attached a sample output file with the chart where i would like it to go - see Running Counts sheet of attached xlsx

[tamilarasu]

Yes. It's not working. I have copied the code from below thread and tried but no luck.

CopyBitmapToClipboard works sometimes but not always

I have tried varies ways but i couldn't find where it's going wrong. Attached file for your reference.

[haymarketpaul]

Oh well - Thanks for your help anyway - interesting link

I guess i'll try pasting the line chart on a new blank sheet and hope they're happy with that.