Hi,
Any body knows how to write a vb script for making a document in excel by taking business objects reports as source and is there any add ins to configure for taking business objects reports in excel 2007.
Thanks
bobj123 (BOB member since 2008-02-12)
Hi,
I’ll try to answer the question on how much I have understood.
You can write a VB script to run the report and after refresh, hyst do teh Save As in EXCEL, one this is done then you cna close the .Rep file and open the EXCEL from the location.
Jsut revert back andif not understood.
This seems to be a post for an report. So please ask the question in the appropriate forum.
Omkar Paranjpe 
(BOB member since 2006-02-13)
Moved to SDK/VBA forum.
Nick Daniels 
(BOB member since 2002-08-15)
You can automate the “save as excel” functionality rather easily … ThisDocument.SaveAs(“filename.xls”). If you’re looking for something a bit more sophisticated, another approach is discussed here …
Using BusObj Reporter/DeskI as data source for Excel/Access
Dwayne Hoffpauir (BOB member since 2002-09-19)