Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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";
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
Objects (tables, graphs) are not available at script time.
You can use an action of type external attached to OnReload trigger
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