Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible, within the ajax client, to create a button that will send a chart to excel? So far from my experience you can only create macros that send objects to excel with the IE Plugin.
It would seem possible because the button on top of the charts works fine, unfortuanitally I need this functionality from a button.
Correct the ID is 45241, but you can try the html format instead:
sub HTML
set tb = ActiveDocument.GetSheetObject("TB01")
tb.ServerSideExportEX "C:\test.html" , ";" , 0
end sub
The only problem with the above is the code/process to get the file from the server to the client, which you will need to write. Regarding things in IE that can block things, the Enable Protected Mode setting is most off the culprit in these cases, so you can be sure your QVServer site is in Local Intranet or Trusted Sites Security Zones, as those should have it disabled by default. Other than that, I would recommend you use Fiddler to trace things, as that will likely give you a better indication as to where things are getting stuck, or you can simply try the F12 Developer Tools option in IE as well, as that may work as well.