Export to Excel through macro in qlickview 9

[#1]

Previously we are using Qlikview 7.5 and able to send mail through macro, but in Qlikview 9 we are getting error

obj.CopyTableToClipboard true

in macro, kindly help it out. Code is written below:-

function SheetIt(ExcelDoc,SheetName,ChartName,Category)
ExcelDoc.Sheets(SheetName).activate
ExcelDoc.Sheets(SheetName).activate
' msgbox SheetName
ExcelDoc.Sheets(SheetName).activate
set obj = ActiveDocument.getsheetobject(ChartName)
obj.CopyTableToClipboard true
ExcelDoc.Sheets(SheetName).paste
ExcelDoc.Sheets(SheetName).cells.select
ExcelDoc.Sheets(SheetName).cells.mergecells = false
ExcelDoc.Sheets(SheetName).Cells.EntireRow.RowHeight = 12.75
ExcelDoc.Sheets(SheetName).Cells.EntireColumn.AutoFit
'msgbox "Category " & Category
ExcelDoc.Sheets(SheetName).name = Category
end function

[#2]

how to add attachment to reply qvw report

[biester]

If you mean you want to add an attachment here: you must "Reply" (not possible with Quick Reply) and can add an attachment on the OptionsTab there.

Rgds,
Joachim

[#4]

I am attaching the qvw file for same.

Its picks data from various sourse , generate excel file and mail

Its required c:\ToSent folder for same

[#5]

Any solution

[#6]

I am attaching the qvw file for same.

Its picks data from various sourse , generate excel file and mail

Its required c:\ToSent folder for same

[#7]

I am attaching the qvw file for same.

Its picks data from various sourse , generate excel file and mail

Its required c:\ToSent folder for same

[#8]

You do one thing..first pay the license cost..cut copy paste dont work always...it is security issue

[#9]

Lots of programing is being done in the given code..so its better read and understand code line by line..then try to correct it..no copy paste....

[#10]

I already mentioned same file wkg with 7.5 but giving error in 9.

So its not security issue it could be memory/clipbord issue

[rajeshvaswani77]

Hi jaswinder,

Would this macro work from Publisher?

Thanks,

Rajesh Vaswani