Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
Firstly, I will describe the context.
I would like to load data from Excel in a QV table.
Moreover, I would like to reload/update data in my QV table if there are modifications in the data from Excel (maybe with a button, I could update data in my QV table).
But, after a lot of research on the web, I still don't know how I can do that and what is the best way (macro VB, or script, ...) ??
Please could you help with my request.
Thank you in advance for your support.
Hello @Vegar ,
Great, if EDX job can help me to launch a macro which reload data from Excel to QV.
Honestly, I never used this functionality of QV.
Please could you share with me some advice, links... to apply an EDX Job in order load/reload data with a macro.
Thank you in advance for your help.
@PrashantSangle as I understand it @Black_Hole wants Excel it self to trigger an reload when the excel is updated hence QlikView can not know when an update i done.
An alternative solution would be to frequently trigger a job in QMC that reads the excelfile change date. When the file date is changed then perform an new load of the file.
Hello all,
Thank you both of you for your help.
@PrashantSangle : Great, I tried your solution and it's exactly what I research. It's an easy and quick way to do what I want (and particularly because I'm a novice in QV).
@Vegar : Thanks a lot for sharing the link. I will learn how I can do to trigger a job in QMC.