BusinessObjects Board

Importing and Exporting reports using VBA Macro

Hi,

My requirement is to import the report from the document domain with a specific category and refresh the reports and publish them to the document domain and also send mails to the users with attachement of the reports as .rep only. Please provide me some sample code.

Thanks,
Shyam.


vsshyam :india: (BOB member since 2003-11-11)

Greetings,

Try looking under Bob’s Downloads. I believe you will find several examples of what you are looking for.

Hope this helps,
Have a wonderful day!


MayhewM :us: (BOB member since 2003-10-22)

Hi Michael,

Thank you very much for reply. I searched in BOB’s downloads but I culdn’t able to find. When I searched I got code to import the report from repository using receive function. But is there any method where I can specify the category name aslo as in Send function.

Thanks in advance.

Regards,
Shyam.


vsshyam :india: (BOB member since 2003-11-11)

Greetings,

Do you have broadcast agent available?

If so, you can do the refresh in BCA and there is no need to import the document.

Use this thread to write vb for sending mail.

https://bobj-board.org/t/15915

Hope this helps,
Have a great day!


MayhewM :us: (BOB member since 2003-10-22)