Re: Excel Macro - Qlik Community

Report Inappropriate Content · ‎2013-06-25

Hello Friends,

As I need help in the macro,

Currently I have a macro selection of three columns after that if I press the Exort button, ther report will be saved.

for instance, I need to select the Customer_id, Cutomer_Number, Customer_Name and then i need to press the Export button.

But the new requirement is as without selection of three columns If I press the Export Button, the report has been saved in the folder.

Is anybody come across such scenorio, if yes means could please share your experience.

Regards

Chriss

vikasmahajan · ‎2013-06-25

Find attachment of qvw Hope will help you.

vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2013-06-25

Hi..pls check..

Sub report()
Set Graph=ActiveDocument.GetSheetObject("CH01")
Graph.AppendExport "C:\Documents and Settings\Desktop\File\File.csv",","
End sub

Regards-Bika