export to excel macro isnt working

[#1]

Hi,

this line in my macro is not working set XLApp = CreateObject("Excel.Application") and I have copied it from examples here in the community!! I'm using qv 11 does anyone know why it is not working?

regards,

MT

[Gysbert_Wassenaar]

If you copied the exact code from a working example then the code probably isn't the problem. But make sure you change references to chart ID's to the ID's of your charts. Possibly you need to change the macro security settings. In the Macro Editor set Requested Module Security to System Access and Current Local Security to Allow System Access.

[#3]

hey thanks for your quick answer I don't know why I haven thought about that 🙂

regards,

MT