topic Re: Error while exporting in a transpose format in QlikView

Error while exporting in a transpose format

padmanabhan_ram — Fri, 07 Nov 2014 10:10:08 GMT

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

Re: Error while exporting in a transpose format

marcus_sommer — Fri, 07 Nov 2014 11:39:37 GMT

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

Re: Error while exporting in a transpose format

padmanabhan_ram — Fri, 07 Nov 2014 12:11:11 GMT

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

Re: Error while exporting in a transpose format

marcus_sommer — Fri, 07 Nov 2014 12:20:13 GMT

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

Re: Error while exporting in a transpose format

padmanabhan_ram — Fri, 07 Nov 2014 12:48:07 GMT

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

Re: Error while exporting in a transpose format

marcus_sommer — Fri, 07 Nov 2014 13:08:05 GMT

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