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

Wed, 14 Apr 2010 14:08:26 GMT

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

Re. :Macro not working on ZFC Client - URGENT !!!!!

Sat, 12 Jun 2010 12:19:36 GMT

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

topic Re. :Macro not working on ZFC Client - URGENT !!!!! in QlikView

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

Re. :Macro not working on ZFC Client - URGENT !!!!!