Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-06-25 03:29 AM

Excel Macro

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

408 Views
0 Likes
2 Replies
vikasmahajan
MVP
MVP
‎2013-06-25 03:49 AM

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.
Montnly Reports in Excel Auto generation.qvw
Make QlikView PDF.qvw
296 Views
0 Likes
Not applicable
‎2013-06-25 03:49 AM
Author

Hi..pls check..

 

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

Regards-Bika

296 Views
0 Likes