COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: shouldknowbetter on 27 Jan 2010 06:01:33 AM

Title: Opening applications from Planning Manager
Post by: shouldknowbetter on 27 Jan 2010 06:01:33 AM
Hi folks,

Can anyone tell me the correct syntax for opening an excel file from within Manager please. I am linking a bitmap and I seem to remember that I need to put the path and executable for excel itself, followed by something (colon, semi-colon) then a space and the name and path of the excel file within single or double quotes. Any definitive reply on exactly what?

Thanks,

Paul
Title: Re: Opening applications from Planning Manager
Post by: shethsameer on 27 Jan 2010 03:11:20 PM

Hi,

If you just need to open excel application then follow the below steps:

1.   In Manager:
2.   Create a Text button
3.   Select the Text button, Click on "Text" on the Tool bar, Click Link
4.   In the dialogue box select 'Start Application'
5.   In the command Line prompt type - EXCEL

If you need to open excel application along with a particular workbook or file then

1.   In Manager:
2.   Create a Text button
3.   Select the Text button, Click on "Text" on the Tool bar, Click Link
4.   In the dialogue box select 'Start Application'
5.   In the command Line prompt type  - Excel "c:\aaa\test_workbook.xls"

Replace c:\aaa\etc... with the file path. Do not remove the " (quotes). This will work, let me know If you face any challenges.

Cheers

Sameer