The dashboard I'm bulding will get data from one sorce, traeat in in form of a pivot table, export it to a new table, then load this new table and use it with other sources... it's kinda messy, Iknow.
There's a way to do this?
Try something like this:
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
I can't make it work... I changed the path* inserted the code on "Main" script and put a CALL function right after it... nothing happens.
I tought it was b/c the script wasn't understanding the end of the function, so I put a ; befoe end sub. Nothing happens.
Any idea what I'm might be doing wrong?
*Path: C:\Users\re09083g\Desktop\EOG Qlikview_12-12\test.xls
you have to do the macro in the Module Editor and change the path and the Obejct ID CH01 by your object ID.
Try this and let me know,
Look at User Poperties, Security menu, one of that options have to allow access to filesystem, also look at your user provileges of the folder you want to use to export