I have a couple qvw's that can't be programmed to be updated at a certain time. The Cost Management team has to run a script that will update the data that is then uploaded into the qvw. I'm looking for a solution to avoid having to be ready and available to click to run the update task for the qvw in the QMC.
I'm considering adding a button to reload and save in the qvw for the cost management team to use when they are ready to update.
However, I've run into a problem : the qvw is a binary load from another qvw.
I've been fiddling around with the following macro to put on my button, so that the user can update the first qvw (that they never see) and then update the final qvw.
Here's what I've got so far, but I think there is a problem in my Set Doc but I'm not sure what.
And I'm then worried that ActiveDocument is a bit too ambiguous.
Any ideas? Is this doable?
Set Doc = App.OpenDoc( [document path and name here] )