Vb macro that would write external excel data then reload the Qvw

[rbalatbat]

Good Day,

I need a VB macro that would updated the excel file then reload the QVW.

User will updated the list of quantity then he/she will click the button Update Excel file and Reload

The macro will update the Quantity list and also the Total Sales to the excel file then reload the QVW

Please use my attached files.

Best Regards,

[datanibbler]

Hi Rafael,

sorry, I cannot help you in the implementation, I've never done it, but for that you need an EDX task that can trigger a reload - there are already some discussions on the issue of EDX reloading here in the Community. Just have a look.