Search results for query: *

Hi, I would like to first say that this site is great and the people here are amazing. Anyway I am wondering if it is possible to integrate Impromptu with MS Access, have VBA open and run imr reports and return back the results as an MS Access table. Even something similar like this will be...

Here is an access vba code it works on access but generates an error upon closing the excel file. -------------------------------- Dim oApp As Object Set oApp = CreateObject("Excel.Application") oApp.workbooks.Open ("C:My documents\report_template.xls") oApp.Visible = True...

Thanks Double D Here is the end result.... Sub Cognosapp() Dim objPPRep As Object Set objPPRep = CreateObject("CognosPowerPlay.Report") objPPRep.Open ("Y:\documents\cognos\budget.ppx") objPPRep.SaveAs ("Y:\documents\cognos\budget.xls"), 4 Set objPPRep = Nothing End Sub

so doubled have you done it before? I dont mind seeing a sample of it. thanks

I was wondering if there is a way for Access VBA to run cognos powerplay as application ala word.application Then save the file as an excel file. I am going to test some codes right now turning my normal office application related vba codes and apply them to cognos.

Thanks for all the solutions all of you brought up. I definitely have to use impromptu on the future until my company fix up my set up on my machine. The thing is that we do not have my sql or sql server. If we do things would be alot easier. I am just starting to use cognos right now.

Thanks Tony it works. How did I not know that. That just boggles me that I didnt see that at all. I feel so stupid.

Well the code works on excel 2000 somehow selection.copy does not work anymore with excel 2003. so how can I replace selection.copy then?

I may have change one of the syntax accidentally that is why this code isnt working anymore. Can anyone tell me why the paste: xlValues part is not working anymore? It parses fine on Excel but the result is that nothing happens except for getting rid of the ODBC links. Formulas still appear...

My microsoft access doesnt have license to use the microsoft common dialog control and hence I am forced to code it manually. Using the code down below, I somehow forgot how and where should I declare these objects. http://www.tek-tips.com/faqs.cfm?fid=2484 this code line needs to be...

Using the code down below, I somehow forgot how and where should I declare these objects. http://www.tek-tips.com/faqs.cfm?fid=2484 this code line needs to be declared Dim cmdlgOpenFile As New clsCommonDialog dim clsCommonDialog as ? I just couldnt remember this at the moment and need help.

I am still having errors on some of the powerplay reports when viewed in Excel does anyone have a solution or reason to why these sort of problems are happening? I just started using this function and so far it has been worthless for me. I am forced to save the powerplay reports into excel...

So ok if it is not possible, what sort of solution would you suggest I should do to go about this? Currently I am forced to create powerplay reports and then save them as excel files and then import them into ms access. Is there a better solution to this problem? There should be one...

Is it possible for MS Access to be able to link to Cognos Powerplay cubes through an ODBC connection? I would like to be able to slice and dice and link various cubes together in Access. Inform me if this is possible.

Thanks yksvaan. I did that, got excel popping up all the ppx files in but here is a problem I have now... somehow the powerplay reports that I have amalgamated/accumulated categories are not popping up in xls but if powerplay report is saved as xls file then it should pop up. I need these...

Where can I get a cognos powerplay excel add in? I know it exist somewhere online. Please inform me to where I can get this add in to add into excel. Thanks