Recent content by Beginner2009

Thanks guys for feedback, drlex, would you please update the query with your remark as I tried but without results. Thanks Jerry, I tried to take yours and update it to my needs but it gives me the same results.

Jerry, did you mean changing my query from: Sub Main() ' ******************* Declare Variables ************************ Dim objImpApp As Object Dim objImpRep As Object Dim strCatalog As String Dim strReport As String Dim strFile As String Dim strCatalogUserId As String Dim strCatalogPassword...

Hi Jerry, Many thanks for your answer. Unfortunately I am still struggling with that error message ("Run-time error '33974': You have to specify the User Class Name when openning catalog in User version of Impromptu"). Can you check what went wrong in the query and why do I have that...

Right, I've worked on it but when I run the query I have have after 5 sec a pop up : "Run-time error '33974': You have to specify the User Class Name when openning catalog in User version of Impromptu" And this the query: Thanks for your help. -------------- Sub Main() ' *******************...

Hi everybody, I was happy to see that people already tried to answer to my question! To clarify a bit I meant using excel as a reporting tool to pull information from Cognos Impromptu. I want to use excel to get impromptu datas and play with these data in excel (chart..): Just a beginner with...

I would like to run impromptu report from excel, is it possible? if yes can someone tell me how to do it as I am not very familiar with VBA.