topic Re: Export table data to excel sheet using macro not working on QV11 in QlikView

Export table data to excel sheet using macro not working on QV11

Sun, 23 Feb 2014 14:12:13 GMT

I am trying to export table data to excel sheet using vb macro, I was able to do export using macro on qv9 server, after migrating same application on qv11 export is not working. do we need to do any additional set up to enable export data to excel using macro.Also Debug option is also not available in QV11 macro window.

Re: Export table data to excel sheet using macro not working on QV11

Anonymous — Sun, 23 Feb 2014 14:53:28 GMT

Hi Nishant,

Please can you attach macro

Re: Re: Export table data to excel sheet using macro not working on QV11

Mon, 24 Feb 2014 05:42:54 GMT

Hi Nitha,

Please find attached test qvw.

Thanks

Nishant

Re: Export table data to excel sheet using macro not working on QV11

ankit777 — Mon, 24 Feb 2014 05:47:23 GMT

you may use the following macro..

sub Export

set obj1 = ActiveDocument.GetSheetObject("TB01")

obj1.ExportBiff "C:\Documents and Settings\596732\Desktop\manasvi\InnerJoin.xls"

msgbox("Done")

end sub

Re: Export table data to excel sheet using macro not working on QV11

Mon, 24 Feb 2014 06:04:35 GMT

Hi,

This Macro is giving message of done, but no excel is getting saved , I changed location to

obj1.ExportBiff "C:\InnerJoin.xls" , after that also no excel file is generated.

Thanks

Nishant

Re: Export table data to excel sheet using macro not working on QV11

ankit777 — Mon, 24 Feb 2014 06:17:35 GMT

Did you change the sheet object name?? In my case it is TB01. Your object id may be different.

Re: Export table data to excel sheet using macro not working on QV11

Mon, 24 Feb 2014 06:27:21 GMT

Hi Ankit,

Object name in my case is also TB01, Actually i think issue is with my set up of qv11 , bcoz same qvw is working on qv9 , only when I am running it on qv11 its behavior is changing. Is there any additional set up is required to enable excel export using macro?.

Thanks

Nishant

Re: Export table data to excel sheet using macro not working on QV11

ankit777 — Mon, 24 Feb 2014 06:33:06 GMT

Are you using version 9 and 11 on same machine or different? And which version of excel are you using?

Re: Export table data to excel sheet using macro not working on QV11

Mon, 24 Feb 2014 06:38:50 GMT

Hi,

version 9 and 11 are installed on two different machine, I am using excel 2013 on qv11 machine and excel 2007 in qv9 machine.

Thanks

Nishant

Re: Export table data to excel sheet using macro not working on QV11

Mon, 24 Feb 2014 07:02:19 GMT

Nishant

You will have to activate sheet first for saving Excel.

Use the following Macro:

Sub SendReport

ActiveDocument.Sheets("SH01").Activate 'edit the sheet

'ActiveDocument.reload

set objExcel=ActiveDocument.GetSheetObject("TB03") 'edit the sheet object

strDate = Year(Date()) &"-"& month(date()) &"-"& Day(Date())

filepath="D:\Macros\Excel_"&strDate&".xls" 'edit the location of file

objExcel.ExportBiff filepath

ActiveDocument.GetApplication.Sleep 5000

End Sub

Re: Export table data to excel sheet using macro not working on QV11

Mon, 24 Feb 2014 11:07:48 GMT

Thank you, Now its working.

Re: Export table data to excel sheet using macro not working on QV11

Mon, 24 Feb 2014 11:10:34 GMT

Hi,

On client machine it is working with internet explorer plugin but full browser version it not working.

Thanks

Nishant

Re: Export table data to excel sheet using macro not working on QV11

Tue, 25 Feb 2014 05:35:13 GMT

Adding to the above note please find the difference between IE and Ajax

AJAX	IE Client Plug in
1. No extra download and Installation required. Good for Chrome, firefox and safari	1.IE plug-in is required
2. Direct tunneling, much faster over HTTPs	2. Faster in selections, depend upon the configuration
3. Good for Mobile Device	3. Feature is not available
4. Requires ports 4747 and 477e open in both client and the server both inbound and outbound	4.This is done over HTTPs. So no port issue. 443 is usually open.
5.MS Office Integration is difficult	5.Microsoft Office drag and drop only available in IE plug in
6.Macro and alert is not possible	6.Alerts can only be created and triggered from Windows (IE Plug-in) versions of QlikView
7. The communication between a QlikView Server and a QlikView Windows client is encrypted. If, however, the AJAX client is used, the communication is not encrypted	7. By default Https. man-in-the-middle and eavesdropping attacks is less possible.