Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to write a JavaScript Macro to export multiple charts data to an excel, but its giving error at CopyTableToClipboard, not sure whether I am doing correct or not, please help me in this
This is the code I am using & also attached error & sample qvw app.
function print_excel()
{
var objXL = new ActiveXObject("Excel.Application");
var objWB = objXL.Workbooks.Add();
var objWS = objWB.ActiveSheet;
//var obj = document.getElementById("TB01")
var obj = ActiveDocument.GetSheetObject("TB01");
var XLSheet = objWB.Worksheets(1);
obj.CopyTableToClipboard = true;
XLSheet.Paste;
//objWS.Range("A1", "L1").Font.Bold = true;
objWS.Range("A1", "Z1").EntireColumn.AutoFit();
//objWS.Range("C1", "C1").ColumnWidth = 50;
objXL.Visible = true;
}
Thanks in Advance
Any help?
Use that line as per below
obj.CopyTableToClipboard(1)
Thanks
Sadick