Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all!
I have a problem with my macro.
I'm trying to merge cell A1:J1. The solutions provided in our community didn't help.
May some of you can tell me what is wrong in my macro.
Thanks in advance!
sub ExExport
Set excelFile = CreateObject("Excel.Application")
excelFile.Visible = true
Set curWorkBook = excelFile.WorkBooks.Add
Set curSheet = curWorkBook.WorkSheets(1)
Set tableToExport = ActiveDocument.GetSheetObject("CH03")
Set chartProperties = tableToExport.GetProperties
tableToExport.CopyTableToClipboard true
chartCaption = tableToExport.GetCaption.Name.v
curSheet.Range("A1") = chartCaption
curSheet.Paste curSheet.Range("A2")
excelFile.Visible = true
curSheet.UsedRange.Columns.AutoFit
curSheet.UsedRange.Rows.AutoFit
excelFile.ActiveSheet.Range("A1:J1").Merge
excelFile.ActiveSheet.Range("A1:J1").HorizontalAlignment = xlCenter
excelFile.ScreenUpdating = True
end sub
If this is working in Desktop and not from QlikView Server, the issue is going to be the Export function/API, you need to use the Server-side API in that case:
ServerSideExportEx
You will find further information in the API Guide QVW file, which I have attached a version for you in case you do not have it.
Regards,
Brett
If this is working in Desktop and not from QlikView Server, the issue is going to be the Export function/API, you need to use the Server-side API in that case:
ServerSideExportEx
You will find further information in the API Guide QVW file, which I have attached a version for you in case you do not have it.
Regards,
Brett