Qlik Community

Ask a Question

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Announcements
Sign up for Qlik's 15-week Applied Data Analytics using Qlik Sense course. Begins Aug. 30th SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export to Excel/Saving with filename

Hi

I'm hoping someone can help me with Macros ('cos I've never used them before).  I've spent the day copying code from the community but can't seem to get any of it to work.

I'm trying to output a straight table to Excel and save it with a filename based on an index/field value from my model.

I've used the following macro, which I stole from here:

     set obj = ActiveDocument.GetSheetObject("CH85")

     obj.ExportBiff "C:\TEMP\test.xls"

Can anyone give me an idea (or better yet, complete code) to allow me to selct an field value (JASPER) from a multibox and run a macro that will save the table as JASPER.xls.

Cheers!

Rob

2 Replies
whiteline
Master II
Master II

Hi.

Try to find APIGuide.qvw. There are useful examples that will help you to get the content of the field.

Not applicable
Author

Thanks whiteline, I poked around the APIGuide yesterday but couldn't see anything obvious (with my lack of knowledge of macros).  I'll have a more thorough look today.

Cheers!

Community Browser