Your issue is that you are trying to run a macro on QVS. Macros can only be run on clients, not on the server. So if you need this macro to be called, you need to do the following:
- Make sure that your htm file exists and the Publisher account has write access to it
- Changing your sub to run OnPostReload() should make sure that the HTML export occurs every reload
- Create a Publisher task to reload the QVW on a schedule & base any relevant dependencies off this task
That should do the trick.
I am getting the error as "Error in writing " when i am trying to export the chart as the HTML page through macro. How ever if i am trying to export the table or the list box as the html Page it is working fine. Is the functionality ExportHTML is applicable only to the Table and list box. And not applicable to the Charts. Please correct me if i am wrong.