Converting reports of .rep type to Excel using Macro

[system]

Hi,
I am using BO 5 version where i want to convert some .rep files to Excel.
I want to convert them using Macro.Can someone provide me a macro which does the conversion.We are able to use the ExportAsPdf method but not able to see ExportAsExcel…Do we need some plugins for Excel method?

---

mdee (BOB member since 2009-11-04)

[system]

Hi,

Check this utility:

Document Converter

Authors: [url=http://www.forumtopics.com/busobj/profile.php?mode=viewprofile&u=1587]OlivierV[/url]: First conversion addin for PDF only with a "basic"-GUI + documentation.. [url=http://www.forumtopics.com/busobj/profile.php?mode=viewprofile&u=505]Avaksi[/url]: Integration of XLS and TXT conversion and GUI redesign. Further discussion on this utility should take place in [url=http://www.forumtopics.com/busobj/viewtopic.php?p=77222#77222]this topic[/url] Author Notes: [quote:11f5678083]The add-…

It may help.

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Hi…
Thanks a lot…it is converting the report to Excel,But the formatting of the Report disappears…Can u help me on this…
And what if i want to convert all the Reports from a repository???Do i need to open all Reports???

---

mdee (BOB member since 2009-11-04)

[system]

The utility does probably all what can be done in BO 5.x version in terms of saving a report into a XLS format.

If you need to preserve the layout of a report then you need to upgrade to a higher BO version where saving into a XLS format is supported.

---

Marek Chladny (BOB member since 2003-11-27)