topic Re: How to generate multiple worksheets from a list in QlikView

How to generate multiple worksheets from a list

Thu, 17 Jan 2013 20:59:14 GMT

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.

Re: How to generate multiple worksheets from a list

Thu, 17 Jan 2013 22:08:11 GMT

Hi,

By using macro-See the attached QVW,

Regards,

Yigal.

Re: How to generate multiple worksheets from a list

Fri, 18 Jan 2013 11:12:03 GMT

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

Re: How to generate multiple worksheets from a list

Fri, 18 Jan 2013 14:16:33 GMT

Hi Franandes,

You are right, the export using Excel,

Wich platform you want to export with?

Regards

Yigal

Re: How to generate multiple worksheets from a list

Fri, 18 Jan 2013 17:49:35 GMT

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