topic Re: Excel Macro in QlikView

Excel Macro

Tue, 25 Jun 2013 07:29:40 GMT

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 — Tue, 25 Jun 2013 07:49:16 GMT

Find attachment of qvw Hope will help you.

vikas

Tue, 25 Jun 2013 07:49:33 GMT

Hi..pls check..

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

Regards-Bika