Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I'm trying to write a macro to write qlik sense data in a new Excel file during load phase. I set
OverrideScriptSecurity=1
StandardReload=0
inside the Settings.ini file and I'm using these commands
Set XLApp = CreateObject("Excel.Application") ;
XLApp.Visible = True ;
inside the script, but I can't see anything working
What am I doing wrong?
Thanks a lot for your help in advance,
best regards,
Nicolò Cogno
There are ways to do this but it depends on if you want to take the time to learn. I have qlik sense server generate a csv file using store command, then have a program called Macro Scheduler that watch the folder for .csv file, reads it and convert and layout the file for me. Macro scheduler is a scripting language, that basically means you can run have any scripting language: ie. AutoHotkey is a free scripting language that reads the csv file and create an excel file: here's the link to the ahk forum: https://autohotkey.com/board/topic/69033-basic-ahk-l-com-tutorial-for-excel/
Would you be willing to share your python script? Looking to do something similar.