Yes, we have tried the following code to try the export from a button:
set cs = ActiveDocument.GetSheetObject("TB01")
This still makes the user wait for the file to be created before they can continue navigating through the application. We then placed another button on the app that opens the export directory in a new browser window.
It's a bit of a long story how they got to the point where they wanted all the data... They are basically under the assumption that if they see it on the screen, then they should be able to download it. What they are most likely to do with it is send it to another party who does not have access to the application.