export to excel

[system]

Hi ,

I am using BO 5.1.4. i have created two reports using one data provider and using macro i want to export to excel file. When i export to excel using Call dp.ConvertTo(ExpExcel, 0, str) statement , a file with first report exported. I want to store the 2 reports in 2 work sheet in a single excel file. Please provide me solution.

Thanks in advance

With regards

---

lwlawrence (BOB member since 2004-09-08)

[system]

You could try this link, see if it helps

Export Report Tabs to MS Excel

The following code will process a document and export each individual report tab to MS Excel. It is currently done in the "AfterRefresh" event but could be called as a subroutine instead. Original Author: Unknown Original Author Comments: [quote:4444a58e6f] Attached is a report based upon the Island Resorts Marketing database which downloads multiple report tabs to a multiple-report tab Excel spreadsheet. It then sends the Excel spreadsheet to a user through Outlook. To test this example: * …

---

David McQueen (BOB member since 2003-11-27)

[system]

Why two reports based on the same DP?

On Document_Refresh; Loop through Application.Documents, running the export code from the previous link.

Should work a treat.

Stu

---

stuartgmilton (BOB member since 2003-01-30)