Hi All,
I have a multi-tab report . But when I click on save in the webinfo I want only one tab i.e. the tab on which i click save as excel to get exported to excel. Is that possible?
ashwin_n84 
(BOB member since 2006-04-25)
it is not possible
KhoushikTTT 
(BOB member since 2005-02-24)
Use VBA code in BO to open an Excel file and delete one tab in it and then close the file…
check the BOB download
It has the code to export the document to Excel …
Black_Measure (BOB member since 2006-06-07)
Ok. lets say you have 15 tabs in you BO report, How is it possible to load all the 15 tabs in a single spread sheet one after the other, Using a macro???
KhoushikTTT (BOB member since 2005-02-24)
Black_Measure…Would it be possible to use a similar bit of code to open the xls file after it has save and change formatings i.e. zoom and gridlines???
Phil A (BOB member since 2006-06-01)