Macro not working on ZFC Client - URGENT !!!!!

[#1]

Hello,

I am using macros to create excel files and populate them from different objects in my application.

I can create the Excel file , adding sheets , but , we it comes to copy information from QV to Excel , it does not work using the ZLC Client (it works locally and using the plugin).

Thanks for your help!

here is the part of the macro that does not do anything using the ZFC Client

ActiveDocument.GetSheetObject("CH61").CopyTableToClipboard True

XLApp.Worksheets.Add().Name= "Scope"
XLApp.Worksheets("Scope").Range("A1").Select()
XLApp.Worksheets("Scope").PasteSpecial
XLApp.Worksheets("Scope").Cells.EntireColumn.AutoFit
XLApp.Worksheets("Scope").Cells.EntireRow.AutoFit
XLApp.Worksheets("Scope").cells.WrapText = false

[#2 · Accepted solution]

I CHANGED THE WAY THE MACRO WORK AND THE PROBLEM IS NOW SOLVED. I AM NOT USING COPY TO CLIPQBOARD ANYMORE.