Help on Excel 1

[Jsadas]

I have few reports in BO, when the user opens them it should be showing in Excel Spreadsheet.

Is there any way to automate this, like a Macro that triggers once the report is generated and exports it to Excel.

Any help would be appreciated!

Regards
Jags

 

[skrandel]

The Broadcast Agent can export text files. If you export with an extension of .tab, then those file will open up in Excel.

In V6, the Broadcast agent can save to Excel directly.

Another option is to use a macro that saves as excel. THese do exist.

Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

 

[Jsadas]

Hi Steve,

Thanks for the update!
Any pointers on where can I get help on Macros or some sample Macors to refer.

Rgds
Jags

 

[skrandel]

Send me and email and I'll send you a macro for exporting to Excel.

Do you have an SDK license. You need one if you are to use macros or scripts.

skrandel@baseconsulting.com

Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

 

[Jsadas]

Thanks for help!

rgds
Jags

 

[funkmonsteruk]

Steve, what does SDK actually stand for, it's been bugging me for ages????

 

[Sridharan]

Software Development Kit

Sri

 

[funkmonsteruk]

Aaaahhhh

 

[skrandel]

And it is not the answer to all the worlds problems. I think the answer "Use the SDK" is wrong about 90% of the time. I have been using BO for almost 7 years and have never had to deploy a script.

Using a script to send email from BCA is fine. Using the SDK to do some automation is fine. But deploying scripts to your users to accomplish some task should be carefully thought about. Most situations can be solved using the product without customization.

Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com