Macro to Export a chart to excel and save to a folder on reload

[paul_ripley]

Hello

I would like to export a chart on reload to a folder and have this in excel (so that the excel file can be used by another app)

I have found some code from another thread but it appears to stop at 'ActiveDocument.Sheets("SH01" ).Activate

I am not very good with Macros, so if anyone could help me understand why the macros would not export to the folder or suggest improvements, that would be much appreciated.

The code is below

Sub ExportFile

ActiveDocument.Sheets("SH01").Activate

set obj1 = ActiveDocument.GetSheetObject("CH109")
obj1.ExportBiff "\\DCL1-QLIK-WV03\QlikView_UDA\III_LIVE\FIN\01_SOURCE_DATA\XLS\TotalAllocs.xls"

ActiveDocument.GetApplication.Sleep 5000

End Sub

Many thanks

Paul

[andrey_krylov · Accepted solution]

Hi Paul. There is no need to activate a sheet for export

Sub ExportFile

     set obj1 = ActiveDocument.GetSheetObject("CH109")
     obj1.ExportBiff "\\DCL1-QLIK-WV03\QlikView_UDA\III_LIVE\FIN\01_SOURCE_DATA\XLS\TotalAllocs.xls"

     ActiveDocument.GetApplication.Sleep 5000

End Sub

and qmc does not execute macros

[paul_ripley]

HI Andrey

That did work.

I will log another question in a minute as I am trying to get triggers to work so that on reload they run macro

Thanks for your help

Paul