Macro through server

[Anonymous]

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?

[Anonymous]

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

[#3]

Hi ,

      How is differ from Eport to Excel functionality ?

Please reply me the same.

//Yusuf

[Anonymous]

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 

[#5]

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.

[brindlogcool]

Hi Paul,

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