Excelappend macro on server

sibrulotte — Mon, 26 Jan 2026 16:26:21 GMT

hi,

I'm running QV11 SR5, users are on the AJAX client, and there are currently two other QV documents running macros on the same server where I am deploying mine.

I have this sub running triggered by a button:

Sub R_commentaire

set v = ActiveDocument.Variables("ExportDir")

ExportPath = v.GetContent.String

ExcelAppend ExportPath &"\Commentaires.xlsx", "CH610"

End Sub

Obviously works wonders on the desktop, but lights and sound are out on the server...

I've read in many threads on the limitation of macros on servers, especially the AJAX client.

But I was wondering if it had anything to do with the Excelappend function.

Is there a way to work with this sub that could append:

Sub ServerExportEx

set v = ActiveDocument.Variables("ExportDir")

ExportPath = v.GetContent.String

Set st = ActiveDocument.GetSheetObject("CH610")

st.ServerSideExportEx ExportPath & "\CH20export.skv" , ";" ,0

End Sub

I haven't actually got it to work either on the server, but if I get an answer that it's the only path, I'll pursue this option.

I'm hoping for a response by mov‌, JohnW‌, gwassenaar‌, swuehl‌, or rwunderlich‌

Re: Excelappend macro on server

sibrulotte — Fri, 12 Jun 2015 15:34:30 GMT

I guess it's not really a popular question

topic Re: Excelappend macro on server in QlikView

Excelappend macro on server

Re: Excelappend macro on server