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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to generate multiple worksheets from a list

for each code a seller need to export a spreadsheet.

So I do not have to filtar each vendor in order to export the result of the selling of it.

4 Replies
Not applicable
Author

Hi,

By using macro-See the attached QVW,

Regards,

Yigal.

Not applicable
Author

Good morning Yigal,

qvw in this macro is giving the line: "Set xlApp = CreateObject (" Excel.Application ")"

Error: The componete ActiveX can not create object: 'Excel.Application'

I do not have Excel on my machine it affects in any way?

according to your qvw I would 3 files each with the product code, product code where is his name and content is the worksheet that contains the values​​.

Sincerely,

Gleybson Fernandes

Not applicable
Author

Hi Franandes,

You are right, the export using Excel,

Wich platform you want to export with?

Regards

Yigal

Not applicable
Author

Yigal,

I made some changes in QVW file you sent me and now we just need to make the second time I generate the files he subscribes existing ones.

Can you help me with that?

follows the attached file.

thankful,

Gleybson