Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

Export table object in EXCEL format

I have tried many macros for this , but all these macros not working please help .

I have tried

SUB export

set obj = ActiveDocument.GetSheetObject("TB01")

obj.exportBiff "C:\Documents and Settings\596732\Desktop\manasvi\abc.xlsx";

end sub

call export;

compiler not processing

obj.exportBiff "C:\Documents and Settings\596732\Desktop\manasvi\abc.xlsx";

3 Replies
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Agnivesh,

Where are you calling the 'call export;' statement?  If it is during reload the screen objects are not at that point rendered so can not be accessed.

I would suggest that you test your macro by assigning a call to it as an action on a button.  If this works you could look at triggering on Post Reload.

Please see my response on this other thread for more details:

http://community.qlik.com/message/443676#443676

Steve

Clever_Anjos
Employee
Employee

Objects (tables, graphs) are not available at script time.

You can use an action of type external attached to OnReload trigger

svsudhakar
Creator
Creator

Hi,

Please create the trigger for calling the macro on post loading.

Settings-->Doc properties--:Add -->Run Macro-->Provide the Macro name

In Edit Module write the below macro code.

sub Export

set obj1 = ActiveDocument.GetSheetObject("CH01")

obj1.Export "D:\InnerJoin.xls",4

msgbox("Done")

end sub 

Regards,

sudhakar