no excel on the server ... can macro use the user excel??

[Anonymous]

I want to create an excel document using macro's in Qlikview ...

The problem I ran into is that we don't have Excel on our Qlikview server (they don't want us to install this on our server since this is a desktop application).

Does anyone know if it is possible to use the Excel on the user side while creating the excel document (after pushing the button in the qlikview application)?? Our users all have the Excel application ...

thx

[#2]

Hi,

You should be able to use the exportbiff macrofunktion without having excel on the server. I have done it.

/Daniel

[Anonymous]

Do you have a small example how exportbiff works??

[#4]

test this small macro:

sub exportbiff
set obj = ActiveDocument.GetSheetObject("CH01")
obj.ExportBiff "C:\test.xls"
end sub

[Anonymous]

So something like

set XLApp = CreateObject("Excel.Application") ' Define Object

will not work ... since we don't have excel on the server (we're not allowed to )

Daniel V wrote:sub exportbiff
set obj = ActiveDocument.GetSheetObject("CH01")
obj.ExportBiff "C:\test.xls"
end sub

This gives the error: Object doesn't support this property or method obj.exportbiff

This way only the object is exported, what I am looking for is to export a complete document containing e.g. 4 tables ...in excel with some layout.

[#6]

Has this issue been resolved?

We have a similar environment and I need to use the "Excel.Application" macro to create the Excel document consisting of multiple tables.

The macro works for users using the QlikView client on their local machines with Excel installed locally. The same user accessing the system via their browser, with Excel installed locally and Excel installed on the server cannot run the same macro.

It must be some security setting or a server limitation??

After much research...

Ok, only solution that works seems to be to use the IE plugin. Ajax ZFC does not work.

Install IE plugin on clients and the entire exprience is changed and macro will execute.

[Anonymous]

H

[Anonymous]

H

[Anonymous · Accepted solution]

Hi,

This can only be resolved by installing Excel on the Server, because this is the place the macro is run ...

Anita