Discussion Board for collaboration on QlikView Publisher.
i have this export to excel macro which is running fine and files are created if i reload the application in desktop .
But if i reload using QMC the macro is not working and Files are not created . i am using Qlikview 11.20 SR12 Publisher version .
dim filesys, newfolder, newfolderpath
set obj = ActiveDocument.GetSheetObject("CH24")
obj.Export newfolderpath&"E:\Live\Source\QV Admin\DataSources\QV Details.csv",","
Macros does not run in QMC. You will have to use a batch reload.
qv.exe /r app.qvw
Schedule it in Supporting tasks External program or Task scheduler in Windows.
This macro may work if you use the IE plugin and without triggering it on reload. It probably will not execute on the server, but it may run well on your client machine.
Check Chapter 81 Using Macros in QV Documents on the QV-Server in the QlikView Reference Manual to learn what does and what does not work in your situation. Especially the trigger limitations.