Error while exporting in a transpose format

[padmanabhan_ram]

Hi there,

I getting the error when running the below macro for transposing a table. Though it's working in the Developer version but it's not working from access point/

sub exportExcel

  set obj = ActiveDocument.GetSheetObject( "CH170" )

   set XLApp = CreateObject("Excel.Application")

  XLApp.Visible = True

  set XLDoc = XLApp.Workbooks.Add

  set XLSheet = XLDoc.Worksheets(1)

  obj.CopyTableToClipboard true

  XLSheet.Paste

  XLApp.Range("A1:DMI3051").Select              

  XLApp.Selection.Copy                        

  XLApp.Range("A3052").Select

  XLApp.Selection.PasteSpecial -4104,-4142,false,true

  XLSheet.Rows("1:3051").Select                  

  XLApp.Selection.Delete    

  XLApp.Range("A1").Select

  XLSheet.Range("A1:A60000").ColumnWidth = 40  

  XLSheet.Range("B1:DMI60000").ColumnWidth = 30  

  XLSheet.Range("A1:A60000").WrapText = true  

end sub

The error has been attached here.

So could any one please help me out in this.

Thanks in Advance,

Padmanabhan

[marcus_sommer]

It will only work with the IE plugin and not with AJAX. Then you need to change the macro security settings from accesspoint-user to allow unsave macros. You will find these settings in:

C:\Users\YOURUSER\AppData\Roaming\QlikTech\QlikView\settings.ini

For testing you could rename these file and then you should be ask by opening this app for the macro-execution.

- Marcus

[padmanabhan_ram]

Hi Marcus,

Thanks for your response but we are not getting such path neither in our client machine nor in server.

Could you please advise.

Best Regards,

Padmanabhan

[marcus_sommer]

C:\Users\YOURUSER\AppData\Roaming\QlikTech\QlikView\settings.ini

AppData is a hidden folder. You need to change the visibility-settings from windows explorer.

- Marcus

[padmanabhan_ram]

Hi Marcus,

Thanks for your details.

we are unable find the settings for macros that you have stated in the settings.ini file.

We have pressed "Ctrl+Shift+M" and given 'Allow System Access" from access point using IE plugin, still no luck!

Could you please advise.

Thanks

Padmanabhan

[marcus_sommer]

Is it possible to export manually from access point to excel?

Then there are security settings within IE (most often global for windows), too. Go to IE --> extras --> internet options --> security and have a look to the diverse ActiveX settings.

Further have a look on the security settings from your qv server within the management console: system --> setup --> your server --> security.

- Marcus