1) i want to know how to load the excel MACRO into QV. the thing is someone else created an excel sheet with some data and have a button with MACRO VB functions. but i want to achieve the button function in QV, but i just not know how
The best way is QV can import the XLS and keep the functions work
The second way is to find way use QV statement to re-write the macro of XLS
The last way is just presenting the result that XLS tools come out
question 2 is i wanto know if QV has the dynamic loading ability.
i have a report each loading will refresh the data, but what i want is to keep the last time loading data puls the newest loading data to caluate the it.
For Question 1, I think you can't load Excel macro into VB. The best way process the date in excel using macro and then finally load the data from Excel file to Qlikview. Since, the calculation part in macro is avoided in Qlikview. Otherwise you need to process data in Qlikview what you did in Excel macro.
For question 2 refer "Using QVD Files for Incremental Load" topic in Help file.
