generate several files to excel

[#1]

Hello,

need to generate several files to Excel.

Let me explain: I have a file with the customers A, B, C and D.

so I want to create an excel file for each client.

You can do this via QlikView?

Sincerely,

Gleybson Fernandes

[swuehl]

Gleybson,

I assume you want to call the export from your front end and not from the script, right?

You would probably need a macro for that to automate the export (you probably know how to select and export a table manually), maybe like described in this post:

http://community.qlik.com/message/59750

Hope this helps,

Stefan

[#3]

Hello Stefan,

I'm right with this post.

but I am having problem in 'Excel.Application'.

I have already put the option to allow access to the system but not resolved.

[swuehl]

You have Excel installed on your system, right?

If you export to Excel manually, e.g. by clicking on the caption icon on a table chart, does this work?

Do you get any error message or similar?

[#5]

Oh yes,

excel 2010

I am attaching the file.

is very simple.

[swuehl]

It worked on my site.

On opening of the application, I was asked to grant security access and selected the least strict level.

Then I ran Test in Module editor. I found four excel files a.xls,b.xls,c.xls,d.xls with restricted data to the selected  cod.

Maybe try to enable appropriate security settings in user settings - security (CreateObject).

Regards,

Stefan

[#7]

Stefan,

you know where I mean to change it to generate CSV?

that way I solve this problem.

[swuehl]

Sorry, you want to know how to export to csv or you already have done this and this solved your problem?

If first, I think you could do this with a code like

sub test

set Obj = ActiveDocument.GetSheetObject("304")

obj.Export "c:\Test.CSV",","

end sub

Regards,

Stefan

[#9]

Hi,

Please see the attached sample enhanced to export to CSV.

Cheers.

[#10 · Accepted solution]

Good morning,

thank you all for your help, I solved the problem by reinstalling office.

Thanks,

Gleybson Fernandes