Have you tried server side export ? Like:
Set st = ActiveDocument.GetSheetObject("CH20")
st.ServerSideExportEx "C:\ProgramFiles\QlikView Server\CH20export.skv"
, ";" ,0
If the need is 'Sheet', then I am afraid as the reference manual says:
The following types of functionality are not to be used in the QlikView Server environment , as they may
cause unexpected results:
- Layout operations acting on the properties of sheets and sheet objects via SetProperties