topic Re: Macro through server in QlikView

Macro through server

Anonymous — Wed, 17 Apr 2013 14:50:10 GMT

Hi guys, i've built a macro to copy a table from qlikview and put it into excel. When i open the document using 'open in server' it simply opens excel and doesn't do anything more. Can anyone help me?

Re: Macro through server

Anonymous — Wed, 17 Apr 2013 14:59:06 GMT

Sorry - should have been clearer. When i run the macro using 'open in server' it simply opens excel and doesnt do anything more.

Re: Macro through server

Wed, 17 Apr 2013 16:14:40 GMT

Hi ,

How is differ from Eport to Excel functionality ?

Please reply me the same.

//Yusuf

Re: Macro through server

Anonymous — Wed, 17 Apr 2013 16:23:31 GMT

Sorry i dont really undersand what you mean. Here is the code i'm using

Sub Export_to_spreadsheet

ActiveDocument.ClearAll true

'ActiveDocument.GetSheetObject("CH336").restore

'Set the path where the excel will be saved

filePath = "H:\TestBB.xls"

'Create the Excel spreadsheet

Set excelFile = CreateObject("Excel.Application")

excelFile.Visible = true

'Create the WorkBook

Set WorkBook = excelFile.WorkBooks.Add

'Create the Sheet

Set Sheet = WorkBook.WorkSheets(1)

'Get the chart we want to export

Set tableToExport = ActiveDocument.GetSheetObject("CH327")

Set chartProperties = tableToExport.GetProperties

tableToExport.CopyTableToClipboard true

'Get the caption

chartCaption = tableToExport.GetCaption.Name.v

'MsgBox chartCaption

'Set the first cell with the caption

Sheet.Range("A1") = chartCaption

'Paste the rest of the chart

Sheet.Paste Sheet.Range("A2")

excelFile.Visible = true

ActiveDocument.GetSheetObject("CH327").minimize

'Cleanup

Set WorkBook = nothing

Set excelFile = nothing

Re: Macro through server

Wed, 17 Apr 2013 16:39:01 GMT

Hi ,

As you said you are performing macro on Server just wanted to check have you tried this macro on your Local machine ( Desktop) . If it is working fine then i think there might be Compability of some macros to run on server ..

But i'm not sure .

Please reply me for the same.

Re: Macro through server

brindlogcool — Tue, 26 Aug 2014 21:12:48 GMT

Hi Paul,

It is old post. I am having the same issue. Would like to understand if you got any solution on this issue.